Answer Posted / virendra

select ename, salary from emp where salary=(select top 1
salary from (select distinct top 3 salary from emp order
by salary desc) a order by salary)

How do you delete a table?

1055

---

Can one improve the performance of sql*loader? : aql loader

1026

---

What is the difference between microsoft sql and mysql?

951

---

What is the difference between function, procedure and package in pl/sql?

1224

---

What is the most important ddl statements in sql are?

981

---

Is primary key always clustered index?

993

---

What is recursive stored procedure?

1085

---

How many functions are there in sql?

1000

---

What is the limitation on the block size of pl/sql?

975

---

What is the usage of distinct keyword?

1049

---

What is pl sql quora?

1127

---

how can we repair a mysql table? : Sql dba

957

---

Write the command to remove all players named sachin from the players table.

1163

---

what is foreign key? : Sql dba

1001

---

The select into statement is most often used to create backup copies of tables or for archiving records?

1056

---