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

What is dba in sql? : SQL DBA

537

What is type and rowtype in pl sql?

539

How do you optimize a stored procedure in sql?

506

what is an extent ? : Sql dba

584

What are the uses of sysdate and user keywords?

632

What are the string functions in sql?

530

Define a temp table?

556

Is sql difficult?

747

What is indexing in sql and its types?

547

Describe sql comments?

565

Explain aggregate functions are available there in sql?

534

What trigger means?

567

What is pl sql record in oracle?

567

Which query operators in sql is used for pattern matching?

547

Explain foreign key in sql?

624