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;

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.

Answer / syam kumar

SELECT * FROM emp order by emp_date asc limit 10;

Answer / laxman

select payment_id,payment_date from care_billing_payment
order by payment_id desc limit 10;
this query give latest 10 rows;

Answer / rajesh

select * from(select * from table_name order by date_column
desc) where rowid<=10

Answer / laxman

SELECT * FROM emp group by emp_date asc limit 10;

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

as a technical developer in oracle applications which type errors feced in your experience sofar

0 Answers   HCL,

what is the difference between TRUNCATE and DELETE command in SQL

23 Answers   ICICI, Saama Tech, SkyTech, TCS,

what is different between inline query,subquery& corelated query?

8 Answers   Quest,

What is the difference between conversions and interfaces? : oracle accounts receivable

0 Answers  

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.

0 Answers  

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

0 Answers  

How many segment are present in Oracle Manufacturing

0 Answers   Oracle,

can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )

1 Answers   IBM, Oracle,

hi all, i have installed oracle xe software in windows 7. iam unable to connect sqldeveloper tool. can you please tell me how to connect. provide completed procedure.

1 Answers  

how can we send a concurrent program output to the clients through mail or fax give me example.

1 Answers   Cap Gemini,

Name three advisory statistics you can collect.

1 Answers  

what is shared memory?

1 Answers   IBM,