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

Can I learn sql in a week?

1029

what are all the different normalizations? : Sql dba

985

Mention what pl/sql package consists of?

956

What is primary key in db?

959

Explain the savepoint statement.

1057

What is indexing oracle sql?

1052

what is self-join? : Sql dba

1085

What are dml commands?

973

What is interval partition?

1019

What is the current version of sql?

994

How do I run sql?

1116

What is difference sql and mysql?

954

What are the types of index in sql?

1036

What is the maximum size of sqlite database?

1068

How do you clear the screen in sql?

1026