Answer Posted / khandu shinde

select a.sal
from (
select sal ,rownum no
from (
select distinct sal
from emp
order by sal desc
)
) a
where a.no=2

what is top in tsql? : Transact sql

1171

---

What is record variable?

1042

---

What are analytical functions in sql?

1079

---

What is a sql instance vs database?

1174

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1057

---

What is offset in sql query?

1176

---

What are dml commands?

1074

---

What is denormalization in a database?

1107

---

What is schema in sql example?

1279

---

Why left join is used in sql?

1019

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1209

---

How to find 3rd highest salary of an employee from the employee table in sql?

1133

---

Can you join a table to itself?

1223

---

Can we use ddl statements in stored procedure?

1192

---

How many sql are there?

1052

---