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 varchar data type in sql?

512

what is the difference between myisam static and myisam dynamic? : Sql dba

579

What is java sql connection?

508

How do I view a sql database?

551

How do I view a sql trace file?

559

how to extract a unit value from a date and time? : Sql dba

550

What is the largest value that can be stored in a byte data field?

516

Can a select statement fire a trigger?

651

what are sequences

1084

What is materialized view in sql?

457

how to select first 5 records from a table? : Sql dba

505

Explain scalar functions in sql?

575

How do you concatenate in sql?

544

How to fix oracle error ora-00942: table or view does not exist

563

What does inner join mean?

549