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

How do I find duplicates in sql?

929

Explain some predefined exceptions.

1028

What is pragma in pl sql?

1103

what is clause? : Sql dba

1060

What is the use of %rowtype?

1034

What is clause in sql?

1108

Can two tables have same primary key?

970

how to create a table index in mysql? : Sql dba

1058

What do you mean by query optimization?

997

What are sql indexes?

996

How to avoid duplicate records in a query?

1005

What is t sql used for?

1010

what are the different tables present in mysql? : Sql dba

980

What is the difference between nvl function, ifnull function, and isnull function?

1101

What is sap sql anywhere?

1068