查询语法（Query syntax）.docVIP

查询语法（Query syntax） Syntax: Select field name, field name, * (*) from, table name, where clause The group by clause, the having clause, the order by clause, the limit clause, and the desc (ASC) The group by clause is a grouping of query results that match the where clause The having clause is a conditional restriction on results after grouping The order by clause sorts the results of the query results, followed by desc or asc. The limit clause is the limit to the number of display results for the query Desc is the final result in descending order, ASC is the final results in ascending order. Example 1: inquire about the student number and name of all students. Select, SnO, sname, from, student; Example 2: inquire about all the students detailed records. Select, SnO, sname, ssex, sage, sdept, from, student; Or select * from student; Example 3: check the names of all the students and the year of their birth. Select, sname, 2004-sage, from, student? Example 4: query the names of all the students, the year of birth, and all departments, requiring lower case letters to indicate all the Department names. Select, sname,year, of, birth:, 2004-sage, islower (sdept), from, student For example, the 5: query takes the number of students in the course (removing duplicate records) Select, distinct, SnO, from, sc; Instructions: using distinct, you can only display duplicate records in query results only once Use column alias: Select, long_field_name_are_annoying, as, myfield, from, thizlinux Use table alias: Select, myfield, from, long_table_name_are_my_table, as, thizlinux Name and age of students under 20 years of age. Select, sname, sage, from, student, where, sage20; Or select, sname, sage, from, student, where, not, sage=20; Use predicates in the WHERE clause: BETWEEN AND: in between NOT BETWEEN AND: not between IN Table : is it in a particular collection (Mei Ju)? NOT IN value table : opposite to the above LIKE: does it match a pattern? IS NULL (empty) or IS NOT NULL (not e