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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sonu
Answer of Ravikumar.s is almost write but there is slightly
mistake, he should write 'desc' keyword instead of 'asc'
because question for latest records not for the oldest
records. So, the correct answer is
select * from (select * from tablename order by datecolumn
desc) where rownum<=10;
One keyword makes the statement and result write or wrong
so, use these carefully.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / syam kumar
SELECT * FROM emp order by emp_date asc limit 10;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / laxman
select payment_id,payment_date from care_billing_payment
order by payment_id desc limit 10;
this query give latest 10 rows;
Is This Answer Correct ? | 6 Yes | 7 No |
Answer / rajesh
select * from(select * from table_name order by date_column
desc) where rowid<=10
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / laxman
SELECT * FROM emp group by emp_date asc limit 10;
Is This Answer Correct ? | 2 Yes | 6 No |
Answer / ranjan satapathy
Your query: to get latest 10 dates from the table
select date_column , *
from table
where date_column between sysdate and (sysdate-10)
will show the latest date upto 10 last day
Is This Answer Correct ? | 2 Yes | 8 No |
How can you gather statistics on a table?
What is difference b/w Credit memo and Adjustment in AR.
which one is currently in used software cmpanies.
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.
what is the difference between TRUNCATE and DELETE command in SQL
23 Answers ICICI, Saama Tech, SkyTech, TCS,
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
Give two methods you could use to determine what DDL changes have been made.
What command would you use to encrypt a PL/SQL application?
When the procedures or packagess become invalidate
Give the stages of instance startup to a usable state where normal users may access it.
How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable