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 / 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
What is the sql query to find the employee who has Nth maximum salary?
What Are Cross Validation & Adi?
Explain prerequisites and post activities of oracle database installation
What is an Oracle database Partial Backup?
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
8. Supporting AP, AR and GL?
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
What is autocashrule set? : oracle accounts receivable
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
can u give guidance abt packages of plsql
Difference between transaction type and transaction sources. : oracle accounts receivable
What is the difference between conversions and interfaces? : oracle accounts receivable
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
Is there any link between pr form(purchse requisition)and po form(purchase order)