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)

What is full form of rtm?

1008

---

What are the types of sql commands?

1103

---

What is sql table?

976

---

Explain two easy sql optimizations.

1016

---

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1095

---

Can we use join in subquery?

1100

---

What is a recursive stored procedure?

1186

---

What is delete command in sql?

1119

---

what is a unique key ? : Sql dba

1096

---

How do I create an index in word?

1035

---

How many tables can you join in sql?

958

---

What is difference between sql function and stored procedure?

1011

---

What is a dynamic query?

1028

---

How can you know that statistics should be updated?

1079

---

when MSQL8.0 is in market

2080

---