How to get top n records

[FishiFishi]

Hi All i want to get top 5 records from the table. what would be the query? Regards Qaiser

[Tirthadip]

Returning only the first N records in a SQL query differs quite a bit between database platforms. Here's some samples: Microsoft SQL Server SELECT TOP 10 column FROM table PostgreSQL and MySQL SELECT column FROM table LIMIT 10 Oracle SELECT column FROM table WHERE ROWNUM <= 10 Sybase SET rowcount 10 SELECT column FROM table Firebird SELECT FIRST 10 column FROM table

Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist