SQL> select ename, sal from emp;
Employee Salary statistics
ENAME SAL
---------- ----------
SMITH 800
ALLEN 1600
WARD 1250
JONES 2975
MARTIN 1250
BLAKE 2850
CLARK 2450
SCOTT 3000
KING 5000
TURNER 1500
ADAMS 1100
JAMES 950
FORD 3000
MILLER 1300
SQL>
SQL> select ename, sal from emp
2 where sal = (select MIN(sal) from emp);
Employee Salary statistics
ENAME SAL
---------- ----------
SMITH 800
SQL>
Bookmark/Search this post with: