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

What is the use of lockboxes? : oracle accounts receivable

661


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

1918


1. What is PO rate variance gain and loss?

2318


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

1935


Explain the use of table functions.

1807






What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

716


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

666


while creating requisitions i am unable to see the list of organisation can anyone help me out ?

1712


What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

630


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?

1654


What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

1601


can u give guidance abt packages of plsql

1648


What are different types of receipt reversals ? Explain them : oracle accounts receivable

732


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

660


What is the difference between conversions and interfaces? : oracle accounts receivable

658