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
Explain recovery process after system failure using checkpoint. Ans: Checkpoint scheme or method is an extra component of the log based recovery system. This scheme is used to

project on dbms

How external/conceptual mapping and conceptual /internal mapping is performed

entity relationship diagram for online examination system

sir we want er diagram of bank management system in this main menu option as new account,deposit amount,withdraw amount,all acount holder list,modify account,close account

Suppose that in an organisation, an employee may do different roles in dissimilar projects. Say, RAM is doing coding in one project and doing designing in another. Suppose that the

Explain the Attribute inheritance Ans: Throughout the rendering of the objects in a view, attribute sets of objects higher in the view hierarchy are inherited via objects below

One-to-many : An entity in A is related with any number of entities in B. An entity in B is related with at the most one entity in A. Example: Relationship between faculty and d

Company Database: a-)Here is the ER Model b-)Here is the Relational Model:     IMPORTANT NOTICE FOR SOLUTION TYPE: ***THIS ASSIGNMENT WILL BE SOLVED BY THE

Why do you go for sorting your query results? SQL SELECT command to fetch data from MySQL table. Whenever you select rows, the MySQL server is free to return them in any order