KEMBAR78
SQL File Q2 | PDF
Scribd
Upload
41 views2 pages

SQL File Q2

The document shows SQL commands used to create an EMPLOYEE table, insert data into it, and run various SELECT queries on the table to retrieve data like counts, maximum salary, distinct departments, minimum salary, and specific columns. The table is then dropped at the end.

Uploaded by

Linda Brown
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
41 views2 pages

SQL File Q2

The document shows SQL commands used to create an EMPLOYEE table, insert data into it, and run various SELECT queries on the table to retrieve data like counts, maximum salary, distinct departments, minimum salary, and specific columns. The table is then dropped at the end.

Uploaded by

Linda Brown
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 2

SQL> CREATE TABLE EMPLOYEE ( Eno varchar(5) PRIMARY KEY,Ename varchar(20),DeptNo

varchar(5),SALARY INTEGER);

Table created.

SQL> INSERT INTO EMPLOYEE VALUES ('E01' , 'Karan' , 'D03', 35000);

1 row created.

SQL> INSERT INTO EMPLOYEE VALUES ('E02' , 'Rishabh' , 'D02', 17000);

1 row created.

SQL> INSERT INTO EMPLOYEE VALUES ('E03' , 'Varun' , 'D03', 20000);

1 row created.

SQL> INSERT INTO EMPLOYEE VALUES ('E04' , 'Karan' , 'D01', 24000);

1 row created.

SQL> INSERT INTO EMPLOYEE VALUES ('E05' , 'Sheena' , 'D01', 22000);

1 row created.

SQL> SELECT * FROM EMPLOYEE;

ENO ENAME DEPTN SALARY


----- -------------------- ----- ----------
E01 Karan D03 35000
E02 Rishabh D02 17000
E03 Varun D03 20000
E04 Karan D01 24000
E05 Sheena D01 22000

SQL> SELECT COUNT (*)FROM EMPLOYEE;

COUNT(*)
----------
5

SQL> SELECT MAX(SALARY)FROM EMPLOYEE;

MAX(SALARY)
-----------
35000

SQL> SELECT DISTINCT (DeptNo)FROM EMPLOYEE;

DEPTN
-----
D03
D02
D01

SQL> SELECT MIN(SALARY)FROM EMPLOYEE;


MIN(SALARY)
-----------
17000

SQL> SELECT Eno, DeptNo FROM EMPLOYEE;

ENO DEPTN
----- -----
E01 D03
E02 D02
E03 D03
E04 D01
E05 D01

SQL> SELECT Eno, DeptNo AS "JOB "FROM EMPLOYEE;

ENO JOB
----- -----
E01 D03
E02 D02
E03 D03
E04 D01
E05 D01

SQL> DROP TABLE EMPLOYEE;

Table dropped.

You might also like