SELECT * FROM EMP A WHERE ROWID NOT IN (SELECT ROWID FROM RAJ WHERE ROW

How do you retrieve the last N records from a table?

Question Posted / rajat

Answer Posted / rajat

SELECT * FROM EMP A
WHERE ROWID NOT IN
(SELECT ROWID FROM RAJ WHERE ROWNUM<=(SELECT COUNT(1) FROM RAJ )-10);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to select all records from the table?

1069

Is sql considered coding?

996

What is the difference between clustered and non-clustered indexes?

1029

Is truncate ddl or dml?

945

what are the 'mysql' command line arguments? : Sql dba

1091

What is sql table?

904

What is auto increment?

936

Differentiate pl/sql and sql?

1013

Is progress software supports to ( pl/sql )?

973

What is auto increment feature in sql?

1069

What is the sql case statement?

954

What is Collation Sensitivity ? What are the various type ?

906

how to convert character strings to numeric values? : Sql dba

1026

when is the use of update_statistics command? : Sql dba

972

When you have to use a default "rollback to" savepoint of plvlog?

1125