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

What is an index in sql?

976

What is #table in sql server?

1016

What are examples of triggers?

1039

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1178

Name the different type of indexes in sql?

928

How do I find the sql server instance name?

939

What is use of except clause? How it differs from not in clause?

991

What is a livelock?

925

Why use “in” clause in sql server?

1018

How to delete a login name in ms sql server?

1018

Tell me what is fill factor?

923

What is named query? : sql server analysis services, ssas

921

Define inner join in sql server joins?

1007

What is 2nf example?

963

How to convert a numeric expression from one data type to another?

967