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

Is sql a backend language?

1144

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2135

---

Is not equal in sql?

1062

---

Is join same as left join?

1080

---

what is uncommittable transactions? : Transact sql

1036

---

What is set serveroutput on?

1179

---

What is database sql?

1097

---

i have some prob lem to tell me about my self in interview first round ...

2215

---

What is pl sql record in oracle?

1088

---

Are stored procedures faster than dynamic sql?

1104

---

What is prepared statement in sql?

1100

---

What is right join in sql?

1153

---

Why is there a need for sqlcode and sqlerrm variables?

1101

---

Which is the correct statement about truncate and delete?

1172

---

How would you convert date into julian date format?

1044

---