Karteikarten
SQL language
Karten in diesem Stapel (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
Informationen
- Beschreibung
- Computer Science Karteikarten am SQL language, erstellt von Ami Mason am 08/05/2018.
- Erstellt von
- Ami Mason
- Aufrufe
- 0
- Bewertung