sql语句 难度（SQL statement difficulty）.docVIP

sql语句 难度（SQL statement difficulty） 2007, 07 Friday, 27 October, at 08:421. a.m., a SQL sentence interview, about group by Table content: 2005-05-09 wins 2005-05-09 wins 2005-05-09 negative 2005-05-09 negative 2005-05-10 wins 2005-05-10 negative 2005-05-10 negative How do I write a SQL statement to produce the following results? Outcome 2005-05-09 22 2005-05-10 12 ------------------------------------------ Create, table, #tmp (RQ, varchar (10), Shengfu, nchar (1)) Insert, into, #tmp, values (2005-05-09, Sheng ) Insert, into, #tmp, values (2005-05-09, Sheng ) Insert, into, #tmp, values (2005-05-09, ` negative) Insert, into, #tmp, values (2005-05-09, ` negative) Insert, into, #tmp, values (2005-05-10, Sheng ) Insert, into, #tmp, values (2005-05-10, ` negative) Insert, into, #tmp, values (2005-05-10, ` negative) 1) select, RQ, sum (case, when, shengfu=, Sheng, then, 1, else, 0, end), wins, sum (case, when, shengfu=, negative, then, 1, else, 0, end), ` negative, from, #tmp, group, by, RQ 2) select, N.rq, N., M., from Select RQ, wins =count (*) from, #tmp, where, shengfu=, wins,group, by, RQ) N, inner, join (select, RQ, minus =count (*), from, #tmp, where, shengfu=, negative,group, by, RQ) M, on, N.rq=M.rq 3) select, a.col001, a.a1 wins, b.b1 negative from (select, col001, count (col001), A1, from, temp1, where, col002=, a, group, by, col001), (select, col001, count (col001), B1, from, temp1, where, col002=, negative, group, by, col001) B Where a.col001=b.col001 2., ask an interview encountered in the SQL statement query The table has the A B C three column, which is implemented with the SQL statement: when the A column is larger than the B column, select the A column, otherwise select the B column, and select the B column when the B column is larger than the C column, otherwise select the C column. ------------------------------------------ Select (case, when, ab, then,, a, else, B, end), (case, when, bc, then,, B, esle, C, end) From table_name 3. interview questions: a