almost 6 years ago
<-- Chapter 21: SQL Injection
SQL Select Top clause is used to retrieve TOP N number of Records or X percent of Records from database table.
Note: All database systems does not support the SELECT TOP clause.
Lets see an example from the below table "employees" :-
SELECT TOP SQL syntax :-
Following is an example of SQL Server
SELECT TOP 3 *
Now run the above SQL query, we will see the output below :-
Now we can see here, Top 3 Rows are displayed.
SELECT TOP PERCENT SQL syntax :-
Following is an example of MYSQL
If we are using ORACLE, Following is an example :-
WHERE ROWNUM <= 3;
SELECT TOP 50 PERCENT *
Now we can see here, Top 50 Percent Rows are displayed.
Chapter 23: SQL Wildcards -->
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?
Terms of Service
| © copyright 2021 FindNerd.com. All rights reserved.
Sign up using