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 is rowtype?

1027

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1011

What is anonymous block in sql?

1126

Does truncate require commit?

979

Can we call stored procedure in function?

965

What are different sql data types?

1053

What is an example of translating a date into julian format?

1125

what is subquery? : Sql dba

1141

What is clustered index sql?

990

What version is sql?

1039

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1077

what is a trigger? : Sql dba

1036

Why do we use joins?

1048

What is database migration?

973

What is full join?

961