how do u find least salary in a table

Answer Posted / kk

SELECT DISTINCT TOP 1 salary
FROM tblemp
ORDER BY salary ASC

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why I have to use stored procedures?

782


Differentiate between sql temp table vs table variable?

667


How can you list all the columns in a database?

720


what is a default tcp/ip socket assigned for sql server? : Sql server database administration

759


What happens when unicode strings concatenate with non-unicode strings?

735






What are the disadvantages of merge replication?

967


What is triggers in ms sql server?

804


Can a database be shrunk with users active?

800


Will sql server 2005 allow you to reduce the size of a column?

704


What are the difference between primary keys and foreign keys?

708


How to include text values in sql statements?

762


What are the different types of sub-queries?

765


Do you know the cursor types?

839


What does it mean if @@cursor_row returns a negative number?

721


What is difference between equi join and natural join?

714