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
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.
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
what is difference between inner join & nested query or subqueries
What are different types of transactions in ar? : oracle accounts receivable
What is an Oracle database Partial Backup?
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
where the dff data will be stored
What is Tax Categories?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
can we use lexical perameter in oracle plsql if yes how
What is the difference between conversions and interfaces? : oracle accounts receivable
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable