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 is character functions?

1016

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1383

What is primary key in db?

933

How do I save a sql query?

961

What is the maximum rows in csv?

856

How do you create a db file?

956

What is clustered and nonclustered index in sql?

893

What is error ora-01000: maximum open cursors exceeded

1060

How to place comments in pl/sql?

1096

Does inner join return duplicate rows?

926

How do I know if I have sql express or standard?

976

What is cursor in pl sql?

1049

how to fetch alternate records from a table? : Sql dba

1050

What is having clause in sql?

926

how to shutdown mysql server? : Sql dba

1027