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

how do u find least salary in a table

Question Posted / saiteja

Answer Posted / saiteja

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Differentiate between SQL and ORACLE joins and write their syntax.

976

How to replace the Query Result 'Null Value' with a text ?

971

What are the 3 types of schema?

1041

how you can list all the tables in a database?

967

Differentiate sql server reporting services vs. Crystal reports?

187

How to drop an existing user defined function in ms sql server?

980

Can coalesce return null?

946

What is the sql server agent?

1032

What is an expression in ms sql server?

1013

What is use of @@ spid in sql server?

1145

Give an example of why you would want to denormalize a database

924

How to backup SQL Server Reporting Services ?

137

What are rest-style architecture's?

170

What happens if null values are involved in arithmetic operations?

962

can any body tell me how to know the password of current user in sql server

2025