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 partition index in sql server?

602

How to delete existing rows in a table?

582

How to create hyperlink from returned sql query ?

618

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

645

How to find the login name linked to a given user name?

528

How to create new databases with "create database" statements?

565

How to create a simple table to test triggers in ms sql server?

505

What are the differences between DDL, DML and DCL in SQL?

754

What is a join in sql?

581

What are user defined functions in ms sql server?

505

What is 1nf 2nf?

545

What is tcl in sql server?

663

What is data modeling and Reterminal integrity?

1489

What is a heap?

615

What is sqlservr.exe - process - sql server (sqlex?press)?

598