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.
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
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?
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What view would you use to determine free space in a tablespace?
What Are Cross Validation & Adi?
Could you please let me know the interfaces in OM / FA??
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
Explain prerequisites and post activities of oracle database installation
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
What is the disk migration? what is the steps involved in oracle disk migration?
Explain the payment term in ar. : oracle accounts receivable