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 enums used for in mysql? : Sql dba

610

What is the sql query to display the current date?

549

What is mdb stand for?

556

What is meant by truncate in sql?

522

How does left join work in sql?

519

What are sql indexes?

545

What is dynamic query?

542

Which tcp/ip port does sql server run?

534

How do I view a sql database?

558

How many clustered indexes can you have?

533

What does t sql mean?

536

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

537

What are data types in pl sql?

564

What is difference between stored procedure and trigger?

535

What is a mutating table and a constraining table?

573