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

How do you use trigger to create mutating state of table

2 Answers   TCS,

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

0 Answers   Pathway Technologies,

what is the difference b/w oracle8i and oracle9i

3 Answers   iGate,

Give two methods you could use to determine what DDL changes have been made.

1 Answers  

I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC

4 Answers   Icon,

What view would you use to look at the size of a data file?

1 Answers  

How do you create a credit note against an invoice? : oracle accounts receivable

0 Answers  

What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?

2 Answers   CTS,

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

3 Answers  

What is auto invoicing? : oracle accounts receivable

0 Answers  

How do you resize a data file?

2 Answers  

how to replace not in with not exist?

0 Answers   IBM,