Answer Posted / tathagoto

select sal from (select sal from salary order by sal desc)
where rownum <4;

Differentiate between pl/sql and sql?

1068

---

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

968

---

What is trigger explain it?

959

---

What does fetching a cursor do?

1018

---

Can a procedure in a package be overloaded?

981

---

Explain foreign key in sql?

968

---

How do I write a cron which will run a sql query and mail the results to agroup?

910

---

What is a call statement? Explain with an example.

949

---

What is foreign key in sql with example?

889

---

What is tuple in sql?

1004

---

How to set up sql*plus output format in oracle?

971

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

989

---

What is difference between table and view?

974

---

What company owns postgresql?

960

---

Is inner join same as self join?

1059

---