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?
- 7 Answers
- 9399 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ravikumar.s
select * from (select * from tblname order by datecolumn
asc) where rownum<=10;
There is no keyword in oracle like limit, only we can fetch
through rownum
in mysql only this limit is available
ex: select col from tbl limit 20;
in sql server we use Top keyword instead of limit;
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
What Are Cross Validation & Adi?
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
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
i want to know about the javaBean.what is its purpose and how it can use in Forms.
how to replace not in with not exist?
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
Explain prerequisites and post activities of oracle database installation
how to write customizations in po
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
Why more redos are generated when the oracle database is in begin backup mode?
