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 to download oracle sql developer?

1058

---

How do I remove sql developer from windows 10?

1016

---

What is cold data?

897

---

What is embedded sql what are its advantages?

962

---

Can a foreign key have a different name?

891

---

How do you respond to dementia behavior?

926

---

What is the difference between left outer join and left join?

945

---

What are the different set operators available in sql?

974

---

Is truncate ddl or dml?

945

---

Explain the uses of database trigger.

1055

---

what are the t string functions available in tsql? : Transact sql

947

---

How do you rank data in sql?

938

---

What is lookup table in sql?

982

---

what is a table in a database ? : Sql dba

991

---

what is a view? : Sql dba

1030

---