Fichas
SQL language
Fichas del conjunto (7)
- 1how would you create a table?create table PUPIL (PUPNUM CHAR (5), PUPNAME CHAR(10));
- 2How to output 2 things from the same tableselect PUPNAME, TEACHNUM from PUPIL
- 3How to output the names of pupils who have the teacher number 307Select PUPNAME from PUPIL where TEACHNUM = 307;
- 4how to change dataUpdate PUPIL set TEACHNUM = 345 where TEACHNUM = 378
- 5output names of all pupils who have the same teacher as pupil 14238Select PUPNAME from PUPIL where TEACHNUM =(Select TEACHNUM from PUPIL where PUPNUM = 14238);
- 6how to sort by fieldSelect * from PUPIL order by PUPNAME
- 7how to write a logical operaterselect NAME from CUSTOMER where FLIGHTNUM = 370 or FLIGHTNUM = 378
Información
- Descripción
- Computer Science Fichas sobre SQL language, creado por Ami Mason el 08/05/2018.
- Creado por
- Ami Mason
- Visitas
- 0
- Valoración