select * from(select * from table_name order by date

A Table has 10,000 records,How can i get latest 10 dates
from the table.so that i can only store those 10 records
in to my Resultset Object,to reduce load on my app?

Question Posted / rajesh

7 Answers
11278 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / rajesh

select * from(select * from table_name order by date_column
desc) where rowid<=10

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between recovery and restoring of the oracle database?

1152

What is the difference between oracle media recovery and crash recovery?

1122

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2466

How do you create a credit note against an invoice? : oracle accounts receivable

1028

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2473

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1093

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

2180

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1076

What is the mandatory setup in cyclecount ?

2698

how to write customizations in po

1562

what are the tools used for oracle 10g in real time.

2376

can we use lexical perameter in oracle plsql if yes how

2268

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2314

What is the sql query to find the employee who has Nth maximum salary?

5216

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2053