select * from <TN> minus select * from <TN> where rownum &l

Write a query to get last 10 records from the table.

Question Posted / siddharthapenchala

Answer Posted / siddharthapenchala

select * from <TN>
minus
select * from <TN>
where
rownum <= (select count(*) - &n from <TN>)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to analyze tables with 'mysqlcheck'? : Sql dba

540

what is error ora-03113: end-of-file on communication channel?

595

What does pl sql stand for?

651

Difference between global and parameter variables?

1450

The select into statement is most often used to create backup copies of tables or for archiving records?

559

What is Materialized View? In What Scenario we Use Materialized View?

8511

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

658

which operator is used in query for pattern matching? : Sql dba

541

What does truncate mean in sql?

532

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

561

define sql delete statement ? : Sql dba

553

How to Execute a Package in PL/SQL.?

576

how to drop an existing index in mysql? : Sql dba

531

How can we find duplicate records in a table?

510

Explain the insert into statements in sql?

561