Answer Posted / durgashivashankar

select min(sal) from (Select rownum,sal FROM emp> Order
by sal desc)
where rownum<=3

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1013

---

how to include character strings in sql statements? : Sql dba

999

---

Enlist some predefined exceptions?

993

---

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

899

---

Does a join table need a primary key?

901

---

what are all types of user defined functions? : Sql dba

995

---

Explain the purpose of %type and %rowtype data types?

875

---

Explain the difference between sql and mysql.

1000

---

What is set transaction?

989

---

What is an implicit commit?

989

---

Why is sql better than hql?

920

---

How much does sql cost?

930

---

What is a composite primary key?

1030

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

3924

---

Define SQL and state the differences between SQL and other conventional programming Languages?

1140

---