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

Does sql support programming?

771

how mysql optimizes distinct? : Sql dba

736

What is ttitle and btitle?

772

what are all different types of collation sensitivity? : Sql dba

715

Does db2 use sql?

677

What are sql functions? Describe the different types of sql functions?

762

What are the different ways to optimize a sql query?

688

What is sql query limit?

705

What is scope and visibility in PL/SQL?

777

What is using in sql?

800

i have some prob lem to tell me about my self in interview first round ...

1898

What is a data manipulation language?

754

Does sql backup shrink transaction log?

739

What is sql*loader and what is it used for?

753

what is the difference between primary key and unique key? : Sql dba

717