Flashcards
SQL language
Cards in this deck (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
Information
- Description
- Computer Science Flashcards on SQL language, created by Ami Mason on 08/05/2018.
- Created by
- Ami Mason
- Views
- 0
- Rating