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

What are views in sql?

962

Is postgresql a nosql database?

1142

What are the different schemas objects that can be created using pl/sql?

1004

What is the difference between subquery and correlated query?

1043

What is sql injection vulnerability?

928

What is rowid in sql?

964

What packages(if any) has oracle provided for use by developers?

5785

How to run sql statements through the web interface?

1021

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

956

What are the features of pl sql?

1049

What is partition in sql query?

983

Is postgresql a server?

1031

what is column? : Sql dba

989

What is normalization in a database?

1143

Is sql sequential or random?

1012