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 are the types of index in sql?

1069

How do you drop a trigger?

990

Is pl sql a programming language?

991

Is sql low level language?

1020

Can a foreign key be a duplicate?

911

What is a pragma statement?

1262

Is it possible to pass parameters to triggers?

1103

What is a function in oracle pl sql?

1038

How many postgresql users are there, worldwide?

1061

how to enter binary numbers in sql statements? : Sql dba

972

define sql insert statement ? : Sql dba

1028

What do you think about pl/sql?

1031

Mention what are the benefits of pl/sql packages?

1081

Mention what is the plv (pl/vision) package offers?

1107

What is varchar data type in sql?

1083