Flashcards
SQL language
Flashcards do 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
Informações
- Descrição
- Computer Science FlashCards sobre SQL language, criado por Ami Mason em 08-05-2018.
- Criado por
- Ami Mason
- Visualizações
- 0
- Avaliação