select * from emp where rowid = (select min(rowid) from emp

how to retrive only second row from table?

Question Posted / ehtesham malik

Answer Posted / ehtesham malik

select * from emp
where rowid = (select min(rowid) from emp
where rowid not in (select min(rowid)
from emp)
)

Is This Answer Correct ?

4 Yes

9 No

Please Help Members By Posting Answers For Below Questions

How do we use distinct statement? What is its use?

1029

What is use of package in pl sql?

1010

What port does sql server use?

1057

Does sql profiler affect performance?

987

Why is stored procedure faster than query?

959

Is record in pl sql?

966

What is an exception in PL/SQL? What are the two types of exceptions?

1309

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1145

How do I remove sql developer from windows 10?

1104

What is a full join?

972

What are primary key and foreign key and how they work?

973

What is data manipulation language?

1187

What are dml commands?

1020

Why commit is not used in triggers?

1038

What is sql entity?

1097