Question

19. Write SQL commands for the following on the basis of given table Teacher:
Table : Teacher
Salary
Name
No.
Dateofioin
Age Department
Computer
Jugal
10/01/97 12000
Sharmila 31 History
24/03/98 20000
Sandeep
Maths
12/12/96 30000
Sangeeta
History
01/07/99 40000
Rakesh
Maths
05/09/97 25000
Shyam
History
27/06/98 30000
Shiv Om
Computer 25/02/97 21000
Shalakha
Maths
31/07/97
20000
32
50
33
(a) To show all information about the teacher of history department
(b) To list the names of female teachers who are in Hindi department
(c) To list names of all teachers with their date of joining in ascending order.
Contact​

Answer 1

Answer:

a) select * from teacher where department is history

b) select * from teacher where department is equal to hindi

c) select * from teacher where dateofjoin order by asc

Explanation:

* means all records