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
Recent comments
15 hours 35 min ago
1 day 17 hours ago
2 days 21 hours ago
3 days 35 min ago
3 days 13 hours ago
4 days 18 hours ago
2 weeks 2 days ago
2 weeks 3 days ago
2 weeks 3 days ago
2 weeks 3 days ago