sql面试题（SQL interview questions）.docVIP

sql面试题（SQL interview questions） 1., the Id in a table has multiple records, check out all of the ID records and show how many records are in total. ------------------------------------------------------------------------------- Select, ID, count (*), from, tab8, group, by, ID, having, count (*) 1 Select * from (select, tab8, count (ID), as, num, from, tab8, group, by, ID) t, where, t.num1 2. use a SQL statement to query the names of each student who is more than 80 points in each class Name Kecheng fenshu Zhang San language 81 Zhang San math 75 Li Si language 76 Li Si math 90 Wang Wu language 81 Wang Wu math 100 Wang Wu English 90 A): select, distinct, name, from, tab9, where, name,, not, in (select, distinct, fengshu=80, name, from, tab9, where, etc) B select * from tab9): T7 where t7.name not (in select t5.name from (select * from (select t1.kecheng from tab9 T1 group by t1.kecheng (select), t2.name from tab9 T2 group by t2.name (T4)), select * from tab9) T5 where t4.name and t4.kecheng = t5.kecheng and = t5.name, t5.fengshu 80) 3., there is a table, which has 3 fields: Chinese, maths, english. Among them, there are 3 records representing 70 points in language, 80 in math and 58 in English. Please check out these three records with one SQL statement and write them according to the following conditions (and write your thoughts): Greater than or equal to 80 indicating excellence, greater than or equal to 60, indicating passing, less than 60 points indicating failure. Display format: Chinese, maths, English Pass well; fail ------------------------------------------------------------------------------------------- Select (case, when, language, =80, then, excellent, when, language, 60, then, pass, else, as, end), Chinese language, (case, when, math, =80, then excellent, when math, 60, then , passing else , failing end , as math), (case, when, English, =80, then excellent, when English, 60, then , passing else , failing end ), as English From tab5 Four Student (S#, Sna