SELECT * FROM emp a WHERE 2 = (SELECT COUNT(rowid) FROM emp b WHERE a.r

how to retrive only second row from table?

Question Posted / umadevi

Answer Posted / umadevi

SELECT * FROM emp a WHERE 2 = (SELECT COUNT(rowid) FROM
emp b WHERE a.rowid >= b.rowid)

now it will work. instead of :n we have mention row number.

Is This Answer Correct ?

26 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What does inner join mean?

1262

Why do we use subquery?

1076

What are the different schemas objects that can be created using pl/sql?

1085

How do I view a sql trace file?

1063

What is a subquery in sql?

1090

what are the advantages of using stored procedures? : Sql dba

1154

What is partition by in sql?

1127

Can a commit statement be executed as part of a trigger?

1104

How you improve the performance of sql*loader? : aql loader

1063

What is sql*loader and what is it used for? : aql loader

1250

What is pls integer?

1091

What is trigger with example?

1170

What is insert command in sql?

1192

What are the types of keys?

1067

what happens if you no create privilege in a database? : Sql dba

1048