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 mandatory setup in cyclecount ?
What is Tax Categories?
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
1. What is PO rate variance gain and loss?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
How do you create a credit note against an invoice? : oracle accounts receivable
which one is currently in used software cmpanies.
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 auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
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?
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.
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.