Answer Posted / praveenpinfo

Suppose table name is EMP.

SQL> Select distinct sal from emp e1 where 2=(select
count(distinct sal) from emp e2 where e1.sal<=e2.sal);

Does truncate remove indexes?

1081

---

How can we make an if statement within a select statement?

1068

---

What are the datatypes available in pl/sql ?

1151

---

What is cold data?

1012

---

what are the advantages a stored procedure? : Sql dba

1018

---

Write a query to find the names of users that begin with "um" in sql?

1045

---

What does inner join mean?

1262

---

How do I partition a table in sql?

1208

---

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

4090

---

Differentiate between syntax and runtime errors.

1242

---

how to get @@error and @@rowcount at the same time? : Sql dba

1082

---

When are we going to use truncate and delete?

1022

---

What is a dynamic query?

1073

---

Does mysql support pl sql?

1231

---

Why plvtab is considered as the easiest way to access the pl/sql table?

1292

---