SELECT DISTINCT TOP 1 salary FROM tblemp ORDER BY salary ASC

how do u find least salary in a table

Question Posted / kk

Answer Posted / kk

SELECT DISTINCT TOP 1 salary
FROM tblemp
ORDER BY salary ASC

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is difference between Datepart() and Datename() in SqlServer?

1263

What is purpose of normalization?

998

Mention the 3 ways to get a count of the number of records in a table.

1025

Why is normalisation important?

989

What are the differences between local and global temporary tables?

1134

What is a dbms wizard?

1074

What is the difference between cartesian product and cross join?

906

What is a Join and explain its types?

1153

What is the contrast between sql and pl/sql?

1200

List out the differences between global and local temp tables in sql server?

1112

what is the different types of backups available in sql server? : Sql server database administration

974

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1101

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1201

How to make conditional sum in ssrs?

183

What is sql profiler. What are the default templates with it? : sql server database administration

1108