Answer Posted / sandeep

select top(1) a.salary
from

(
select top(2)sal
from
employee
order by salary desc
)a
order by a.salary asc

Describe sql comments?

1029

---

What are the different sql languages?

1031

---

How can the performance of a trigger be improved?

1038

---

What is union and union all keyword in sql and what are their differences?

1099

---

What is procedure function?

1049

---

Is sqlexception checked or unchecked?

964

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7325

---

What are local and global variables and their differences?

1086

---

What is insert command in sql?

1122

---

what are set operators in sql? : Sql dba

1046

---

Define commit, rollback and savepoint?

1021

---

What are sql queries used for?

1023

---

Which data dictionary views have the information on the triggers that are available in the database?

1232

---

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

4011

---

Write a sql query to convert all character to uppercase after hypen.

1433

---