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
define normalisation and functional dependency

Discuss deferred update technique of recovery.  What are the advantages?  Ans:  The deferred update methods do not physically update the database on disk till after a transact

What is MySQL? MySQL is a relational database management system which has eleven million installations. It can be used for both Linux and Window. Managing database includes add

What are the several forms of identity? a) Value b) Name c) Built-in

Project Description: My VBulletin forum was hacked, and soon after my server machine died. So, I'm now on a new machine, and I think that I've taken care of 99% of the hacking..

Why is database redesign necessary? Database redesign is essential for two reasons. First, redesign is essential both to fix mistakes made during the initial database design. S

XYZ is a large chain of home entertainment rental over 100 stores distributed over all states in Australia. XYZ lends entertainment products such as movies, TV shows and games on v

how many types of data model in DBMS? explain data abstraction with its different level

1.Why we need data mining? Give an example to illustrate your answer. 2. Why data mining is considered as "misleading name"? 3. Distinguish the difference between database an

Database Recovery And Security Introduction In this part we will introduce two main issues relating to database management systems. A computer system suffers from dissi