A key word in the SQL programming language used to signify which table(s) we are using, e.g. SELECT Name, Age, Class ____ Students_table WHERE Gender = ‘Male’ A key word in the SQL programming language used to order the output from a SELECT query, e.g.SELECT Name, Age, Class FROM Students_table WHERE Gender = ‘Male’ ____ Class A key word in the SQL programming language used to add a new record into a database table.” e.g. ____ Students_table VALUES (021, ‘Amanda Jones’, 15/10/1980, ‘F’, ‘VRO’, ‘H739’) A key word in the SQL programming language used to remove records from a database table.” e.g. ____ FROM Students_table WHERE Tutor group = ‘FMC’ Complete the SQL statement to output all the data from the the Class table ____ ____ ____ Class Complete the SQL statement to print a sorted list of Student surname and Class name,joining the Student to the Class table using the Student.ID primary Class.StudentID foreign key ____ surname, Class.name ____ Student, Class ____ Student.ID = Class.StudentID ____ surname

GCSE.U7.SQL Statements

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?