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

What is a native sql query?

1078

---

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1051

---

What is memory optimized table?

1049

---

What is sql keyword?

1006

---

Mention what are the benefits of pl/sql packages?

1084

---

What is the use of desc in sql?

978

---

How do I run a sql query?

1026

---

What is rank function in sql?

1031

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1227

---

What is the sql*loader? : aql loader

1056

---

how to include character strings in sql statements? : Sql dba

1077

---

What is the difference between pl and sql?

1096

---

Is big data nosql?

954

---

What is a composite primary key?

1096

---

What does pragma mean?

1060

---