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

Explain transaction server isolation?

979

What is normalization of database? What are its benefits?

960

List types of tables in SQL Azure?

126

Why we use the openxml clause?

955

How will you hide an attribute? : sql server analysis services, ssas

891

Can we write trigger for view?

951

Can sql servers linked to other servers?

972

What do you understand by physical_only option in dbcc checkdb?

932

What xml support does the sql server extend?

954

What are the rendering extensions of ssrs?

142

Can sql server 2016 run on windows 7?

860

What are the built in functions in sql server?

917

what is a traditional network library for sql servers? : Sql server database administration

892

Explain primary key?

898

Explain “@@rowcount” and “@@error” in sql server?

1004