Database Paging (Oracle,mysql,sqlserver)

Syntax for SQL Server:

SELECT TOP number|percent column_name (s) from table_name

MySQL syntax

SELECT column_name (s) from Table_namelimit number

Example

SELECT *from Personslimit 5

Oracle syntax

SELECT column_name (s) from Table_namewhere ROWNUM <= number

Example

SELECT *from personswhere ROWNUM <= 5

SELECT *
From (select RowNum as r,directory,content from SQL) tab
WHERE Tab.r>ceil (sum/pagesize) * (page-1) and Tab.r<=ceil (sum/pagesize) * (page-1)
sum--Total number of bars
pagesize--How many lines a page
page--first few pages

Database Paging (Oracle,mysql,sqlserver)