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 update query?

920

What is data modelling in sql?

962

what is commit? : Sql dba

1026

What is an escape character in sql?

979

What is procedure explain with example?

894

Explain the uses of a database trigger?

982

What is the function that is used to transfer a pl/sql table log to a database table?

950

Why does sql need a server?

988

What is crud sql?

921

Can we commit inside a trigger?

942

How do you write an inner join query?

890

Can we use having without group by in sql?

927

Why we use pl sql?

907

Does google use sql?

912

What is clustered and nonclustered index in sql?

894