select ename,sal from emp where sal=(select min(sal) from emp);

how do u find least salary in a table

Question Posted / saiteja

4 Answers
6395 Views
I also Faced
E-Mail Answers

Answer Posted / saiteja

select ename,sal from emp
where sal=(select min(sal) from emp);

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is repeatable read?

986

How can you find out which stored procedures are recompiling?

906

Is it safe to delete log files?

899

How you provide security to cube? : sql server analysis services, ssas

950

Can sql server be linked with other servers like oracle?

944

Can a table be moved to different filegroup?

960

Why the trigger fires multiple times in single login?

1188

Is sql server difficult to learn?

904

What are Spatial data types in SQL Server 2008

999

what type of index will get created after executing the above statement? : Sql server database administration

961

What are the advantages to use stored procedures?

1082

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

What are the transaction properties?

995

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

915

What does the on update no action do?

999