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?

Answer Posted / laxman

SELECT * FROM emp group by emp_date asc limit 10;

Is This Answer Correct ?    2 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Could you please let me know the interfaces in OM / FA??

1751


What is Restricted Mode of Instance Startup in Oracle?

690


What is mrc and what is its use? : oracle accounts receivable

639


Where in the Oracle directory tree structure are audit traces placed?

2133


I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1506






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

1647


What is auto invoicing? Explain : oracle accounts receivable

622


1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

1658


what is difference between inner join & nested query or subqueries

2496


which gives Oracle R12 Financial training in delhi please give me answer its urgent?

1928


Differentiate between transaction type and transaction source? : oracle accounts receivable

687


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

1920


what are the API of GL,PO,AP

1787


What is the disk migration? what is the steps involved in oracle disk migration?

731


as a technical developer in oracle applications which type errors feced in your experience sofar

1919