select * from(select * from emp order by rowid desc)where rownum=5;

how to find 5th row ?

Question Posted / krish

Answer Posted / krish

select * from(select * from emp order by rowid desc)where
rownum=5;

Is This Answer Correct ?

1 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Can we create view in stored procedure?

943

What is difference between sql and excel?

1067

Can we use having without group by in sql?

963

Which is faster count (*) or count 1?

1009

What are the various restrictions imposed on view in terms of dml?

955

Do we need to create index on primary key?

903

What is clustered and nonclustered index in sql?

926

Explain the working of foreign key?

1043

What are pl sql data types?

993

Why should I use postgresql?

998

how to use regular expression in pattern match conditions? : Sql dba

1014

Show code of a cursor for loop.

1043

What is insert command in sql?

1104

What does sign mean sql?

1071

what is recursive stored procedure? : Sql dba

970