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 many types of triggers exist in pl/sql?

1048

What does joining a thread mean?

1003

Can we call stored procedure in function?

938

What is sql stand for?

970

How do I run a query in pl sql developer?

975

What is a sql schema used for?

1077

What is difference between stored function and application function?

1172

Define sql delete statement.

988

Can we use pl sql in mysql?

994

What is db journal file?

1034

Which sql statement is used to return only different values?

984

What is the difference between an inner and outer join?

998

What is restrict in sql?

1091

How many disk partitions should I have?

974

What is a database trigger?

1050