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 do you mean by an execution plan? How would you view it?
Why is sql server log file full?
Can you explain what are various ways to enhance the ssrs report?
How can your resolve deadlocks?
4 Answers IBM, IMS, Iron Mountain, NuWare,
What is the difference between coalesce() & isnull()?
Mention the different authentication modes in sql server.
Does order by actually change the order of the data in the tables or does it just change the output?
What are entities and relationships?
Questions on identity?
What is data modification?
What are different backups available in sql server?
What is replication with database mirroring? : sql server database administration
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)