sql check if temp table exists

than 50Select Banji as Class, COUNT (*) as number of people from Student1 where tizhong>40 GROUP by Banji have COUNT (*) >3Class sizeClass Two 4Class Three 4Five Class 7--See several English scoresSELECT distinct English as results from Student1Achievements5.533.033.535.545.060.063.070.077.078.079.086.087.088.090.093.0100.0--View all the information of all math scores 88 and 99 studentsSelect *from student1 where math in (88, 99) 20 Zhao Wei men 70.0 23 66.0 99.0 45.0 class four

Tags: har use int rom base data table date Multicolumn--Create a databaseCreate DATABASE hq20161114Go --Using the databaseUse hq20161114Go --Create student tablesCREATE TABLE Xuesheng(code int,Name varchar (10),Sex char (10),Chengji Decimal (18,2)) --Add student informationINSERT into Xuesheng values (1001, ' One ', ' male ', 11)INSERT into Xuesheng values (1002, ' two ', ' Male ', 2

· What is a database?The warehouse where the data is stored.· What is the difference between a database and a data structure?To solve the problem of manipulating data in memory, the database should solve the problem of manipulating data in the hard disk. Data structures study some abstract data models (ADT) and some of the operations defined on the model, the database is composed of tables, relationships, operations.· What is a primary key?The primary key is used to identify the uniqueness of th

--Create a databaseCreate DATABASE hq20161114Go--Using the databaseUse hq20161114Go--Create student tablesCREATE TABLE Xuesheng(code int,Name varchar (10),Sex char (10),Chengji Decimal (18,2))--Add student informationINSERT into Xuesheng values (1001, ' One ', ' male ', 11)INSERT into Xuesheng values (1002, ' two ', ' Male ', 22)INSERT into Xuesheng values (1003, ' three ', ' female ', 33)INSERT into Xuesheng values (1004, ' four ', ' female ', 44)Go-