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
6457 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 a sql join?

1029

How do you delete a trigger?

987

What are the properties of the relational tables?

881

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

1018

How to modify an existing user defined function?

1114

Explain transaction isolation levels in sql server?

1125

What is a view in sql?

979

Can we call stored procedure in view in sql server?

904

What is acid db?

892

Explain error and transaction handling in sql server?

1018

What is parameterized reports in ssrs ?

150

Do you know what is user defined datatypes and when you should go for them?

968

Explain Geometry datatype in sql server 2008 with example

998

How many null values we can have in a unique key field in sql server?

961

Which language is supported by sql server?

1019