Question

What is the use of SELECT Query? Write its Syntax. Write SELET querty
for below given table to gel Name Salary of female employees who are
working in Administration department.
Emp-id Emp-Name Gender Department Salary
101 Ram
Male Administration 15000
102 Seeta
Female Administration
18000
103 Shyam
Male Teaching
55000
104
Geeta
Female Administration 15000​

Answer 1

Answer:

syntax :

select * from. table name

select name, salary

from employees

where Gender='Female' and Department='Administration';

Explanation:

select statement used to display the data from table..extract the data from table