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

Why do we use subquery?

944

What is pl sql in oracle?

992

Is record in pl sql?

918

What is oracle sql developer?

994

What is row_number () in sql?

935

What is sql basics?

992

Define implicit and explicit cursors.

1076

How can we store rows in PL/SQL using array?

1162

What is data modelling in sql?

964

when MSQL8.0 is in market

2016

What does joining a thread mean?

975

What are types of indexes in sql?

1010

Why do we create views in sql?

1055

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

994

what is heap table? : Sql dba

1049