Answer / srinivas

select * from <table name>
where rownum<=2
order by last_updated_date

Answer / ashok kumar lenka

We can solve this by the help of Trigger.
The trigger is for update.which store the update time of the
record of the table. So my query is like this
>select * from emp where to_char(update_column,'dd')=2;

Answer / narenkumar reddy

select column_name from table_name
where column_name=sysdate-2

How do I create a sql script?

0 Answers  

---

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra

2 Answers   Zensar,

---

Which command is used to call a stored procedure?

0 Answers  

---

Can you alter start with clause?

1 Answers   TCS,

---

what is the difference between inner and outer join? Explain with example. : Sql dba

0 Answers  

---

What is the use of stored procedures?

0 Answers  

---

What are different types of sql commands?

0 Answers  

---

What are the different dml commands in sql?

0 Answers  

---

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

1 Answers   TCS,

---

Can a primary key be a foreign key?

0 Answers  

---

What is difference between stored procedures and application procedures?

0 Answers  

---

Explain the difference between sql and mysql.

0 Answers  

---