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 single-user mode?

915

---

What is Service Broker in sql server 2012?

1010

---

How can I tell if sql server is 32 or 64 bit?

938

---

What are click through reports?

142

---

How extra digits are handled with numeric data type literals?

948

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

987

---

what are the types of indexes? : Sql server database administration

1100

---

What is change data capture (cdc) feature?

1044

---

What do you mean by sql server 2005 express management tools?

1289

---

Write a query to find 5th highest amount paid from the customer table.

923

---

Where do we use trace frag?

1000

---

What is meant by referential integrity?

997

---

What are the purpose of Normalisation?

1040

---

How do I open a .db file?

1022

---

What is the purpose of update statistics and scope_identity() function?

1084

---