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

What types of commands can be executed in sql*plus?

1090

Which sql most popular?

975

What is the difference between delete, truncate and drop command?

1126

Can we perform dml in function?

1050

Does execute immediate commit?

1196

Is null operator in sql?

1014

Explain the select statement in sql?

1095

What is primary key sql?

1015

What does trigger mean in psychology?

947

how can we know the number of days between two given dates using mysql? : Sql dba

1028

how can we destroy the session, how can we unset the variable of a session? : Sql dba

981

What does cursor do in sql?

1004

What are different types of indexes?

996

Can a composite key be null?

960

Is foreign key mandatory?

988