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 data types in sql?

533

How can I make sql query run faster?

558

Explain what is table in a database?

577

What plvcmt and plvrb does in pl/sql?

874

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

532

How many triggers can be applied on a table?

510

What is difference between hql and sql?

503

What are the different types of constraints?

561

what is unique key constraint? : Sql dba

564

Can we write ddl statements in functions?

564

What is the most restrictive isolation level? : Transact sql

554

What is mutating table error?

661

What port does sql server use?

504

What is minus?

541

Which join is default?

519