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

What steps server process has to take to execute an update statement?

919

What is asqueryable?

902

Is coalesce faster than isnull?

906

What is natural join in sql?

916

How many types of cursors supported in pl/sql?

1092

Which join is like inner join?

973

What can sql server reporting services do?

1052

What is example of database?

984

Explain the savepoint statement.

1037

how tsql statements can be written and submitted to the database engine? : Transact sql

921

List the different type of joins?

996

What is a ddl command?

1003

Can a key be both primary and foreign?

943

Do we need to create index on primary key?

851

how to use like conditions? : Sql dba

1036