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
What is the use of lockboxes? : oracle accounts receivable
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
1. What is PO rate variance gain and loss?
what are the tools used for oracle 10g in real time.
Explain the use of table functions.
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
What is the difference between recovery and restoring of the oracle database?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
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?
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?
can u give guidance abt packages of plsql
What are different types of receipt reversals ? Explain them : oracle accounts receivable
Explain the process of recievables in oracle financials. : oracle accounts receivable
What is the difference between conversions and interfaces? : oracle accounts receivable