How can fetch Top N Records from database. ?

Q) How can fetch Top N Records from database. ?
Ans :- 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-name 

PostgreSQL and MySQL

    SELECT column FROM Table-name LIMIT 10

Oracle

SELECT column FROM Table-name WHERE ROWNUM <= 10

Firebird

SELECT FIRST 10 column FROM table

InterBase 

SELECT * FROM Table-name rows 10