How do I return a specific row number in mysql without using the where clause?

Question

How do I return a specific row number (row 60) in MySQL without using the where clause?

SELECT * FROM TABLE

I mean to say, i have number of rows in table eg. (1-100) or i want to get 60 number row without using WHERE [PRIMARY_COLUMN]=60; — Kuldeep Singh, May 09 '17 at 07:52
Possible duplicate of [Select specific row from mysql table](http://stackoverflow.com/questions/10457458/select-specific-row-from-mysql-table) — Draken, May 09 '17 at 08:10

score 0 · Accepted Answer · edited May 09 '17 at 07:35

0

SELECT * FROM my_table ORDER BY `[column name]` `[ASC or DESC]` LIMIT 0,60

edited May 09 '17 at 07:35

Tom

answered May 09 '17 at 07:32

Thomas Rbt

this return 0-60 numbers of rows i want only 60 number row. – Kuldeep Singh May 09 '17 at 07:55
So change it to *59,1* instead of *0,60* – Draken May 09 '17 at 08:11
Why do you not use `WHERE` ? You can do as Draken said, but if your table is not ordered or if you have some duplicates numbers, it will not work. – Thomas Rbt May 09 '17 at 08:34

1 Answers1