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
Describe Parameteric end users? Parametric end users might be given update access, but are commonly not permitted to change the structure of data.

Describe log based recovery The most usably structure for recording data base modification is the LOG the log is a sequence of log records recording all the update activities i

Consider the following database schema: STAFF(StaffNo, fName, lName, Position, sex, dob, branchNo) BRANCH(BranchNo, Street, City) Assume the following for the above database

How many types of Views are there? There are Four types of views:- Database View Help View Projection View Maintenance View

An entity set that does not have sufficient attributes to form a primary key is called? An entity set that doesn't have sufficient attribute to form a primary key is known as w

What is the use of unique function? UNIQUE function: If UNIQUE is specified then only unique values are used to computed the mean.

What are the benefits of OOA technology? Using OOA technology can produce many benefits, such as:  i) Reusability of code  ii) Productivity is gained through direct mappi

Explain the Exec statement in SQL Ans: Exec statement has the structure    EXEC SQL END-EXEC   Embeded SQl statements are of a form identical to non embedded SQL statem

Define physical and logical data independence. How does this architecture help in achieving these? Data independence entails that change in one view must not need a change in t

Explain the three data models namely relational, network and hierarchical and evaluate their relative advantages and disadvantages. Hierarchical Model: In hierarchical model, da