Answer Posted / chitti

Hi Viewers here is the simple query to find the highest
salary:-

1)Highest five salaries:-

select top 5 salary from employee order by salary desc

2)Highest 5th salary:-

select top 1 salary from(select top 5 salary from
employee order by salary desc) temp1 order by salary asc

3)Highest 4th salary:-

select top 1 salary from (select top 4 salary from
employee order by salary desc) temp1 order by salary asc

4)Highest 3rd salary:-

select top 1 salary from (select top 3 salary from
employee order by salary desc) temp1 order by salary asc

5)Highest 2nd salary:-

select top 1 salary from(select top 2 salary from
employee order by salary desc) temp1 order by salary asc

6)Highest 1st salary or highest salary:-

select max(salary) from employee

How many types of literals are available in pl sql?

1122

---

How to load data with sql*loader?

1054

---

What are the sql aggregate functions?

1137

---

what is view? : Sql dba

971

---

how to create a new view in mysql? : Sql dba

942

---

what is a table in a database ? : Sql dba

1047

---

What are operators available in sql?

1051

---

Which is faster truncate or drop?

1047

---

What is memory optimized table?

1049

---

What are the types of records?

992

---

What is dml statement?

961

---

What is java sql drivermanager?

1104

---

Why is nosql good?

1032

---

What is the use of pl/sql table?

1070

---

what is self join and what is the requirement of self join? : Sql dba

1145

---