Whenever the limit clause will be used, Database Management System

Whenever the LIMIT clause will be used?

LIMIT is used for the following kinds of problems:

1) Answering questions about first or last and largest or smallest

2) Splitting a result set into sections so that you can method it one piece at a moment.


Posted Date: 7/31/2013 2:09:37 AM | Location : United States

Related Discussions:- Whenever the limit clause will be used, Assignment Help, Ask Question on Whenever the limit clause will be used, Get Answer, Expert's Help, Whenever the limit clause will be used Discussions

Write discussion on Whenever the limit clause will be used
Your posts are moderated
Related Questions
What is Nested Queries explain in details? Nested Queries - A SELECT query could have subquery(s) in it. While a SELECT query having another SELECT query in it, is known as n

What are the key features of Oracle? Key features of Oracle are as follows: • Read Consistency • Concurrency • Locking Mechanisms • Quiesce Database • RAC • Portability

What are composite objects? Objects that have other objects are known as complex objects or composite objects.

Define query optimization. Query optimization refers to the process of search the lowest -cost method of evaluating a given query.

Project Description: Looking to prepare automated trading engine for alternate cyprto currencies starting with Cryptsy, finally integrating into other exchanges. Need to work wi

Process of normalization is the integral part of designing a database. Justify this statement with suitable database design

Define DBMS? DBMS: database management system (DBMS) is computer software designed for the reason of supervision databases based on a variety of data models.

When every condition appears with equality condition (=) only. c)   Natural join (denoted by R*S) When two join attributes have the similar name in both relations. (Tha

The H. I. Topi School of Business operates international business programs in 10 locations throughout Europe. The school had its first class of graduates in 1965. The school keep