how do u find least salary in a table
Answers were Sorted based on User's Feedback
Answer / sreeja.t.pillai
SELECT MIN(EmpSal) Min_Salary FROM Employee_Details
Is This Answer Correct ? | 14 Yes | 1 No |
Answer / kk
SELECT DISTINCT TOP 1 salary
FROM tblemp
ORDER BY salary ASC
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / saiteja
select ename,sal from emp
where sal=(select min(sal) from emp);
Is This Answer Correct ? | 1 Yes | 0 No |
SELECT MIN(SALARY) from EMPSAL
OR
SELECT MAX(SALARY) FROM
(SELECT DISTINCT TOP 1 SALARY
FROM EMPSAL ORDER BY SALARY) AS A;
Is This Answer Correct ? | 1 Yes | 4 No |
What is use of except clause?
What you can do to delete a table without the delete trigger firing?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
How to connect of datebase with sql express.?
What is unique key constraint?
What the class forname () does?
How do you load large data to the SQL server database?
What is a NOLOCK?
How to populate a table in sql server?
What is trigger explain with program?
Explain transaction server distributed transaction?
How do I install sql server?