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 different categories of sql commands?

1114

what is timestamp in mysql? : Sql dba

1052

Name three sql operations that perform a sort.

987

what is the difference between clustered and non clustered index in sql? : Sql dba

1105

What is difference between inner join and cross join?

952

How many functions are there in sql?

999

What is a record in a database?

1040

What are the main features of cursor?

1065

What does truncate mean in sql?

1000

Differentiate between sga and pga.

1142

What's the difference between inner join and left join?

984

What will you get by the cursor attribute sql%notfound?

1040

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1045

Why indexing is needed?

973

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

989