Answer Posted / indraneelandhavarapu

SELECT MIN(SALARY) from EMPSAL

OR

SELECT MAX(SALARY) FROM
(SELECT DISTINCT TOP 1 SALARY
FROM EMPSAL ORDER BY SALARY) AS A;

what is the difference between a primary key and a unique key? : Sql server database administration

948

---

How to recompile stored procedure at run time?

1006

---

How to send email from database?

953

---

What is sql server database?

939

---

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1117

---

What is a DBMS, query, SQL?

998

---

What is replication with database mirroring? : sql server database administration

988

---

What are dml triggers and types of dml triggers?

924

---

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

181

---

What is a data collection table?

948

---

What are the advantages of user defined function?

921

---

What are the types of subscriptions in SQL Server replication?

963

---

How to create dbo table in sql server?

901

---

What is the difference between ddl,dml and dcl commands?

1059

---

how to avoid cursors? : Sql server database administration

906

---