select * from employees where rowid=(select max(rowid) a from employee

how u can find the n row from a table?

Question Posted / karunakar

Answer Posted / karunakar

select *
from employees
where rowid=(select max(rowid) a
from employees)

Is This Answer Correct ?

1 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Can pl sql procedure have a return statement?

560

what is the difference between where clause and having clause? : Sql dba

545

How do I run sql?

631

Is it important to partition hard disk?

541

what are the limitations of identity column? : Transact sql

617

How do I truncate a word?

535

What does pragma mean?

520

What are predefined functions in sql?

544

Can we create clustered index without primary key?

535

Does truncate release storage space?

570

What is a schema sql?

539

What is a natural join?

527

What is right join in sql?

567

What is the difference between union and union all command?

565

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

730