almost 4 years ago
The SELECT TOP clause is used to return specific number of records with thousands of records. It is used to select top N number of records from a table. We can use number or percent to select record.
TOP clause is not supported by all the databases.
For e.g- MySQL uses LIMIT
Oracle uses ROWNUM
MS SQL uses TOP
Syntax of SELECT TOP:-
Syntax of LIMIT:-
To display elements in ascending or descending order:-
[ORDER BY expression [ ASC | DESC ]]
LIMIT number_rows [ OFFSET offset_value ];
Syntax of ROWNUM:-
In place of number we will give the number of rows we want to be selected.
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
© copyright 2017 FindNerd.com. All rights reserved.
Sign up using