how can i write as selcet querry which returns only 'n 'number of rows from a table?

Question

I want to desplay a search result in a web page. In a page there should be a maximum of 20 results. on request it will desplay the next 20 result on the same page. How can i write a query which returns only 20 rows from a table?

Answer 1

{select stmt} LIMIT {start},{number}

where {select stmt} is your query.
{start} is the first record you want to bring back (depending on the DB may start with 0 or 1)
{number} is the number of records.

Answer 2

The answer will vary depending on the database you are using. For example, in Oracle you can write the query like this:

SELECT colName1, colName2... FROM TableName WHERE criteria1 AND criteria2... AND rownum<=20;

Hope this helps

Answer 3

What type of database are you using and whats an example of your query?

Answer 4

SELECT TOP 20 COLUMNNAMES FROM TABLENAME

Answer 5

select top 20 blah blah blah...