SELECT * FROM tab a WHERE :n = (SELECT COUNT(rowid) FROM tab b WHE

how to retrive only second row from table?

Question Posted / sagar

Answer Posted / sagar

SELECT * FROM tab a
WHERE :n = (SELECT COUNT(rowid)
FROM tab b
WHERE a.rowid >= b.rowid);

Is This Answer Correct ?

14 Yes

33 No

Please Help Members By Posting Answers For Below Questions

What are stuff and replace function?

1065

What is difference between procedure and trigger?

962

What is procedure explain with program?

997

What is data types in sql?

983

What is row_number () in sql?

964

Can procedure in package be overloaded?

1064

Whis is not false in primary key?

1443

What is cte?

963

How do you rank data in sql?

983

Which certification is best for sql?

974

What is the most important ddl statements in sql are?

981

What are keys in sql?

980

How do you delete a table?

1055

how to drop an existing view in mysql? : Sql dba

1043

What is sql query optimization?

1090