SQL_ORACLE-/SQL_14.text at main · VANDANAREDDY73/SQL_ORACLE- · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
SQL> SELECT MIN(400) FROM DUAL;

  MIN(400)
----------
       400

SQL> SELECT MIN(SAL) FROM EMP;

  MIN(SAL)
----------
       800

SQL> SELECT MIN(DEPTNO) FROM DEPT;

MIN(DEPTNO)
-----------
         10

SQL> SELECT MIN(EMPNO) FROM EMP;

MIN(EMPNO)
----------
      7369

SQL> SELECT MIN(EMPNO,DEPTNO) FROM EMP;
SELECT MIN(EMPNO,DEPTNO) FROM EMP
       *
ERROR at line 1:
ORA-00909: invalid number of arguments


SQL> SELECT MIN(EMPNO),MIN(DEPTNO) FROM EMP;

MIN(EMPNO) MIN(DEPTNO)
---------- -----------
      7369          10

SQL> SELECT MIN(ENAME) FROM EMP;

MIN(ENAME)
----------
ADAMS

SQL> SELECT MIN(HIREDATE) FROM EMP;

MIN(HIRED
---------
17-DEC-80

SQL> SELECT MAX(SAL) FROM EMP;

  MAX(SAL)
----------
      5000

SQL> SELECT MAX(ENAME) FROM EMP;

MAX(ENAME)
----------
WARD

SQL> SPOOL OFF;