Untitled

mail@pastecode.io avatar
unknown
plain_text
7 months ago
373 B
1
Indexable
Never
Create table TEACHER(Name varchar(20), Age int, Department varchar(20), Dateofjoin date, Salary numeric(6,2), Sex Varchar(10));

Select * from TEACHER where 
Department='computer';

SELECT NAME, SALARY FROM TEACHER WHERE
 SEX='MALE' AND DEPARTMENT='maths';

select NAME from TEACHER
ORDER BY DATEOFJOIN ;

SELECT NAME, SALARY, AGE FROM TEACHER
WHERE SEX='MALE';
Leave a Comment