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 are locks in sql?
What is the purpose of forms?
how to do partition in sqlserver
what is hash table
What is index in an assignment?
Can we hide the definition of a stored procedure from a use?
What is RMS migrations?
How to drop an existing stored procedure in ms sql server?
what is mean by crystal repoart? ahere we will mainly use that?
If a stored procedure is taking a table data type, how it looks?
What is exporting and importing utility?
Explain different isolation levels?