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 dml with example?

508

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

545

What is varray in pl sql?

558

What are sql objects?

531

What are the datatypes available in pl/sql ?

602

What is audit logout in sql profiler?

582

what is user defined functions? : Sql dba

540

State some properties of relational databases?

572

What are the rules to be applied to nulls whilst doing comparisons?

739

How can a function retun more than one value in oracle with proper example?

574

What is data types in sql?

527

How to select 10 records from a table?

639

What is the execution plan in sql?

546

Which is better stored procedure or query?

536

What is normalisation in sql?

538