try this works in mysql select * from table

how u can find the n row from a table?

Question Posted / pradeep

Answer Posted / pradeep

try this works in mysql

select * from table_name limit n-1,1;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is sql*loader?

1202

how to use in conditions? : Sql dba

1021

What are the benefits of pl/sql packages?

1116

Is json a nosql?

986

Which is faster joins or subqueries?

997

Can we use update in sql function?

1071

Why do we use joins?

1055

Explain the uses of control file.

1055

what are the limitations of identity column? : Transact sql

1114

Why functions are used in sql?

1002

What is the difference between partitioning and sharding?

1017

How do I run sql profiler?

1080

Is sql a dbms?

1024

How long will it take to learn pl sql?

946

What is rtm in testing?

1124