Menu
I have to select the top 25 records from a table according to the column Num.
There are two issues. First, the table is not sorted by Num. I know this can be resolved by using GROUP ORDER BY. Second, the number of the records in the table might be less than 25.
Is there any way to perform this selection in just one SQL statement?
829
For example, TOP(10) would return the top 10 rows from the full result set. Optional. If PERCENT is specified, then the top rows are based on a percentage of the total result set (as specfied by the top_value). For example, TOP(10) PERCENT would return the top 10% of the full result set.
To verify the contents of the table use the below statement: SELECT * FROM Employee; Now let's display the Nth record of the table. Syntax : SELECT * FROM <table_name> LIMIT N-1,1; Here N refers to the row which is to be retrieved.
For SQL Server:
select top 25 * from table order by Num asc
For mySQL:
select * from table order by Num asc limit 25
Oracle:
Select *
FROM Table
WHERE rownum <= 25
MSSQL:
SELECT TOP 25 *
from Table
Mysql:
SELECT * FROM table
LIMIT 25
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
