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 are all different types of collation sensitivity? : Sql dba

982

Which are sql * plus commands?

1130

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1004

How long it takes to learn pl sql?

1011

Explain the select statement in sql?

1112

What is difference between primary and secondary key?

1028

what is unique key constraint? : Sql dba

1037

Why do we use function in pl sql?

1065

How can I make sql query run faster?

1017

What is field delimiter?

1048

explain the options of myisamchk to improve the performance of a table. : Sql dba

1011

Is pl sql still used?

978

Is sql better than excel?

1156

What is pl sql collection?

971

What is the difference between function and procedure in pl/sql?

1086