SELECT * FROM emp order by emp

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 / syam kumar

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

Answer Posted / syam kumar

SELECT * FROM emp order by emp_date asc limit 10;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

HOW TO SPOT AHIERARCHY?

2302

Explain the process of recievables in oracle financials. : oracle accounts receivable

1157

Are These Dff's Flexible?

1180

what are basic modules required to implement oracle application in any oraganisation?

2216

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2081

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

2445

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3589

What view would you use to determine free space in a tablespace?

2227

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2285

What is auto invoicing? Explain : oracle accounts receivable

1130

default triggers available for reports

2225

difference of using cursor for loop and open,fetch,close.which one is better

1810

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2224

what is difference between inner join & nested query or subqueries

3052

What is an Oracle database Full Backup?

1137