Answer Posted / swapnil tikale

Select top 1 salary from (select distinct top 2 salary from employee order by salary desc) as sal order by salary ;

what happens if you no create privilege in a database? : Sql dba

940

---

Why truncate is used in sql?

938

---

What is scalar and vector?

940

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1047

---

What is difference between pl and sql?

994

---

What is the difference between partitioning and sharding?

950

---

What are transaction and its controls?

968

---

Why are sql stored procedures used?

990

---

What is write ahead logging in sql server?

990

---

What are inner and outer joins examples of both?

881

---

Explain what is a subquery ?

1125

---

what is a materialized view? : Sql dba

999

---

What is exit statement?

959

---

Which function is used to return remainder in a division operator in sql?

1076

---

What is posting?

990

---