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

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 Answers  

Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?

1 Answers  

Whats the purpose of using Nextval while creating the sequence.

2 Answers   HCL,

How would you determine what sessions are connected and what resources they are waiting for?

0 Answers  

What is Tax Categories?

0 Answers  

key flexfield structure

0 Answers   Infosys,

How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

2 Answers   Cap Gemini, Syntel,

Name two files used for network connection to a database.

1 Answers  

How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun

8 Answers  

How would you determine who has added a row to a table?

0 Answers  

Why more redos are generated when the oracle database is in begin backup mode?

0 Answers  

Describe what redo logs are.

1 Answers