Answer / sreeja.t.pillai

SELECT MIN(EmpSal) Min_Salary FROM Employee_Details

Answer / kk

SELECT DISTINCT TOP 1 salary
FROM tblemp
ORDER BY salary ASC

Answer / saiteja

select ename,sal from emp
where sal=(select min(sal) from emp);

Answer / 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 service broker?

0 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---

Is candidate a key?

0 Answers  

---

write an SQL query to list the employees who joined in the month of January?

0 Answers   Agilent, Amdocs,

---

Why would you call update statistics?

0 Answers  

---

---

Is trigger fired implicitely?

2 Answers  

---

What is a trigger and types of a trigger?

0 Answers  

---

how to invoke a trigger on demand? : Sql server database administration

0 Answers  

---

What happens when converting big values to integers?

0 Answers  

---

what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?

2 Answers  

---

what is datawarehouse?

0 Answers   Informatica,

---

How to generate create table script on an existing table in ms sql server?

0 Answers  

---