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 is a temporal data type?

1114

When is a declare statement required?

1197

Can we join same table in sql?

1068

What are pl sql data types?

1056

Which sql statement is used to delete data from a database?

1009

Why we use join in sql?

1026

what is the difference between a local and a global temporary table? : Sql dba

1130

How to process query result in pl/sql?

1203

what are sequences

1824

What is a recursive stored procedure?

1254

Explain sql data types?

1145

What is the need of a partition key?

1030

Can we use delete in merge statement?

1101

what are the differences between binary and varbinary? : Sql dba

1085

What is varchar example?

1081