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

Can we create index on primary key?

1018

What are the benefits of pl sql?

1176

What is dynamic sql in pl sql?

1089

Can we join more than 2 tables in sql?

1093

What is the use of index in hive?

1052

How global cursor can be declare with dynamic trigger ?

2270

How to return an array from java to pl/sql?

1181

What trigger means?

1036

What are tables and fields?

1087

explain what is mysql? : Sql dba

1131

define join and explain different type of joins? : Sql dba

1001

What is the difference between pl and sql?

1153

what is the difference between sql and t-sql? : Transact sql

1136

What is the difference between a database and a relational database?

1154

What are the syntax and use of the coalesce function?

1273