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 Object oriented Model ? Object Oriented Model - This model is based on the object-oriented programming language paradigm. It involves the features of OOP such as inhe

Consider an information system designed for an online company which provides IT products and services. These include desktops, laptops, networking products, IT books, parts, and te

In a job interview with a branch manager of a bank that operates in multiple Canadian provinces and the Yukon, you learn that all of the information is captured in real time in a s

List the SQL domain Types? SQL supports the following domain types. 1) Char(n) 2) varchar(n) 3) int 4) numeric(p,d) 5) float(n) 6) date.

Question 1 Discuss on transmission impairments Question 2 What is framing? Question 3 Write a note on 10Base2 10Base- T Question 4 Explain the rev

Need for Multiple Access Paths In practice, most of the online information systems need the support of multi-key files. For example, consider a banking database application hav

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

Example: Consider the following relations: ROLLNO NAME ADDRESS COURSE_ID 100 Ka

Oracle Fusion Middleware: Key Skills: Consulting,Architect, Oracle Fusion Middleware,ECM, UCM, Stellent,Identity Management, SOA Suites, BPEL, ESB,OAM,OIM,J2ee, Java, Livelink

Consider the subsequent relations RENTER(rno, fname, lname, address, tel_no, pref_type, max_rent) VIEWING(rno, pno, date, comment) PROPERTY_FOR_RENT( pno, street, area ,city,