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)

Write an sql query to select all records from the table?

1046

---

What is dml and ddl?

971

---

Does pl sql work in mysql?

989

---

Mention what does the hierarchical profiler does?

1104

---

What is cold data?

968

---

What is sql injection owasp?

1073

---

What is the difference between a primary key and a unique key?

1064

---

Can we use view in stored procedure?

910

---

What is self-join and what is the requirement of self-join?

1154

---

What is mutating table error?

1195

---

What is indexing in sql and its types?

1092

---

What are the benefits of stored procedures?

1081

---

What is the use of non clustered index?

1003

---

how to do backup entire database? : Transact sql

1155

---

Why truncate is used in sql?

1014

---