Database Paging Query

Paging Statements :

Oracle:

--This paging query method is not only for simple query of single table, but is complex for the inner query.

--Multi-table union queries or the most internal queries contain sort as valid

SELECT  *  from  ( 

select   rownum  RN , T.*   from  

( select  * &NBSP, from  ftnemr. Patient_visit)  t  where Span style= "Color:rgb (0,0,128); font-family: ' Courier new ' ">&NBSP; rownum &NBSP;<=&NBSP; 40  )  

WHERE RN >= +

ORDER by patient_id;

--This is a much lower performance than the above approach

SELECT  *  from  ( 

select   rownum  RN,&NBSP;T.*&NBSP; from &NBSP;

( select Span style= "Color:rgb (0,0,128); font-family: ' Courier new ' ">&NBSP;*&NBSP;  ftnemr. patient_visit)  T   

where  rn   between &NBSP; 21 Span style= "Color:rgb (0,0,128); font-family: ' Courier new ' ">&NBSP; and &NBSP; 40 &NBSP; Span style= "Color:rgb (0,0,128); font-family: ' Courier New ' ">

ORDER by patient_id

SQL Server:

-- Find out from article I to article No.

SELECT TOP Ten * FROM dbo. HIS_BA1

WHERE FID not in (SELECT TOP of the FID from dbo. His_ba1 ORDER by FID)

Mysql:

SELECT *  from Table LIMIT 5,Ten;//retrieving Record lines6- the