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 normalization of database?

0 Answers  

---

What is 2nf example?

0 Answers  

---

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

0 Answers  

---

Is the log file is a part of file group?

0 Answers  

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

---

---

What are the different types of stored procedures?

0 Answers  

---

Do you know what is a with(nolock)?

0 Answers  

---

Explain powershell included in sql server 2008?

0 Answers  

---

what is the query and condition to delete datas in sql server.

2 Answers  

---

How the authentication mode can be changed?

0 Answers  

---

What is the use of group by clause?

0 Answers  

---

How to display a past time in days, hours and minutes?

0 Answers  

---