Answer Posted / uday kiran

Its is like Nth highest salary.....


Select * from Employee where salary =
(Select max(Salary) from Employee where salary < (Select max
(Salary) from Employee where
Salary<(Select max(Salary) from Employee where
Salary <…………………………………………… N

How many tables can a sql database have?

925

---

what are the features and advantages of object-oriented programming? : Sql dba

952

---

How do you use a while loop in pl sql?

940

---

What happens when a trigger is associated to a view?

840

---

What are the various levels of constraints?

1059

---

What are the two types of exceptions in pl/sql?

965

---

What is a memo field?

901

---

What is the purpose of primary key?

966

---

What are different sql data types?

954

---

How many types of index are there?

958

---

Why do we use view in sql?

909

---

What is character functions?

1016

---

What are sql queries used for?

978

---

how to calculate expressions with sql statements? : Sql dba

980

---

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

3925

---