May 4, 2012

Select specific row from mysql table

Question by Marlon Brando

Ideally I need a query that is equal to

select * from customer where row_number() = 3

but thats illegal.

I cant use an auto incremented field.

row_number() is the row that needs to be selected.

How do I go about this?

EDIT: Well, I use iSql*plus to practice, and using limit and auto_increment is illegal for some reason. I ended up creating a sequence and a trigger and just uped the id by 1 everytime there was an entry.

Answer by Starx

You cannot select a row like that. You have to specify a field whose values will be 3

Here is a query that will work, if the field you are comparing against is id

select * from customer where `id` = 3
...

Please fill the form - I will response as fast as I can!