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 is the difference between clustered and non-clustered index in sql?

1017

How can I tell if sql is running?

1067

Mention what does plv msg allows you to do?

1124

What is the command used to fetch the first 5 characters of a string?

1210

how to get @@error and @@rowcount at the same time? : Sql dba

1028

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1162

How exception handling is done in advance pl/sql?

983

Explain the difference between rename and alias?

1015

What is compute?

1095

What is assignment operator in pl sql?

1042

How do I remove sql developer from windows 10?

1115

Explain how can you save or place your msg in a table?

1029

Can we rollback delete command?

990

What is difference between joins and union?

1129

what is isam? : Sql dba

1015