SELECT * FROM emp e WHERE 1> (SELECT COUNT(1) FROM emp f WHERE

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

Question Posted / a g srikanth

Answer Posted / a g srikanth

SELECT *
FROM emp e
WHERE 1>
(SELECT COUNT(1) FROM emp f WHERE e.rowid<f.rowid
);

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do I make my sql query run faster?

907

How many databases can sql express handle?

952

What is view explain with example?

902

What is index example?

969

What are sql*plus environment variables?

1054

What is the purpose of normalization?

1011

What is difference between procedure and trigger?

937

what is oracle database ? : Sql dba

988

Is merge a dml statement?

941

What is the difference between left join and right join?

910

How does one load ebcdic data? : aql loader

1123

Why is sharding used?

964

how to shutdown mysql server? : Sql dba

1052

What is difference sql and mysql?

954

How many postgresql users are there, worldwide?

1023