select the TOP N rows from a table

Question

I am making some paging  and I need to make some query and get the result form defined slicing   for example  I need to get all  top  rows in range 20n  lt   x  lt  40n etc   SELECT   FROM Reflow   WHERE ReflowProcessID   somenumber ORDER BY ID DESC    and now I need to make my sliding by column called ID    Any suggestions how to so    I need to run my query on mysql  mssql  and oracle

User · Answer

you can also check this link SELECT   FROM master question WHERE 1 ORDER BY question id ASC LIMIT 20 for more detail click here

User · Answer

Assuming your page size is 20 record  and you wanna get page number 2  here is how you would do it   SQL Server  Oracle   SELECT     --  lt -- pick any columns here from your table  if you wanna exclude the RowNumber FROM  SELECT ROW NUMBER OVER ORDER BY ID DESC  RowNumber           FROM Reflow         WHERE ReflowProcessID   somenumber  t WHERE RowNumber  gt   20 AND RowNumber  lt   40       MySQL   SELECT    FROM Reflow   WHERE ReflowProcessID   somenumber ORDER BY ID DESC LIMIT 20 OFFSET 20

User · Answer

In MySql  you can get 10 rows starting from row 20 using   SELECT   FROM Reflow   WHERE ReflowProcessID   somenumber ORDER BY ID DESC LIMIT 10 OFFSET 20 --Equivalent to LIMIT 20  10

User · Answer

From SQL Server 2012 you can use a native pagination in order to have semplicity and best performance  https   docs microsoft com en-us sql t-sql queries select-order-by-clause-transact-sql view sql-server-ver15 using-offset-and-fetch-to-limit-the-rows-returned Your query become  SELECT   FROM Reflow   WHERE ReflowProcessID   somenumber ORDER BY ID DESC  OFFSET 20 ROWS   FETCH NEXT 20 ROWS ONLY

User · Answer

select   from table name LIMIT 100   remember this only works with MYSQL

[mysql] select the TOP N rows from a table

Examples related to mysql

Examples related to sql

Examples related to sql-server

Examples related to oracle