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 an sql server agent?

0 Answers  

---

What is a field name?

0 Answers  

---

How do I setup a local sql server database?

0 Answers  

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---

What are three SQL keywords used to change or set someone?s permissions?

3 Answers  

---

Suggest a method of joining two tables.

0 Answers   Ernst Young, Thomson Reuters,

---

What is an execution plan? When would you use it?

0 Answers  

---

How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  

---

Can we take the full database backup in log shipping?

0 Answers  

---

How to find the date and time of last updated table?

3 Answers  

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

0 Answers  

---

What is table join?

0 Answers  

---