SQL query getting items from a table ONE AT A TIME?

Question

suppose there's a hundred product with x=a

this query will return the FIRST item

SELECT TOP 1 product_name FROM table_name WHERE x='a'

Now how do i get the second, third, fourth... i dont know the id of the fields, i dont know any other elemets in the table.

Answer 1

Clearly you are using Transact-SQL, so the previous answer utilizing the OVER clause is correct.

In MySQL, you can provide an offset to the LIMIT predicate:

SELECT prroduct_name FROM table_name WHERE x = 'a' LIMIT (1,1)

LIMIT (1,1) would give the second record; LIMIT(2, 1) would give the third; LIMIT (3, 1) would give the fourth, etc.

Answer 2

It is predicated upon the variety you're construction the question. i'm not an sq. jockey so I maximum oftentimes use OO3.a million Base layout View. There are field choose and variety possibilities that enable me a good looking intense degree of specificity in construction queries. You positively could get those extra fields out of there to diminish down you're loading situations.

Answer 3

It depends on the Database.

For SQL Server it would be

SELECT product_name FROM ( SELECT Row_Number() OVER (ORDER BY product_name) as rowid, product_name FROM table_name WHERE x='a') as T where rowid = yyyyy


replace yyyyy with your desired row number
Good Luck
M.

Answer 4

try to use a "cursor"