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

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

0 Answers  

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

0 Answers   Cap Gemini,

what are the API of GL,PO,AP

0 Answers  

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

what are the tools used for oracle 10g in real time.

0 Answers   IBM,

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,

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

0 Answers  

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

0 Answers  

Whats the purpose of using Nextval while creating the sequence.

2 Answers   HCL,

Explain the difference between a data block, an extent and a segment.

1 Answers   Accenture, IBM,

what is correlated subquery

3 Answers  

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

0 Answers