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

Explain dml and ddl?

552

What does rownum mean in sql?

558

What is the difference between local and global temporary table?

553

Explain alias in sql?

586

When is a declare statement required?

677

What is user in sql?

585

What is the maximum number of columns in sql table?

551

How can we optimize a sql query?

580

how to run 'mysql' commands from a batch file? : Sql dba

612

What is difference between table and view?

530

What is nested table in pl sql?

555

Is primary key an index?

539

What are different types of indexes?

512

What are the types of functions in sql?

569

Why having clause is used in sql?

547