快速掌握一些異常精妙的SQL語句

SQL:?select?*?into?b?from?a?where?11

SQL:?insert?into?b(a,?b,?c)?select?d,e,f?from?b;

SQL:?select?a.title,a.username,b.adddate?from?table?a,(select?max(adddate)?adddate?from?table?where?table.title=a.title)?b?　

SQL:?select?a.a,?a.b,?a.c,?b.c,?b.d,?b.f?from?a?LEFT?OUT?JOIN?b?ON?a.a?=?b.c

SQL:?select?*?from?日程安排?where?datediff('minute',f開始時間,getdate())>5?　　

SQL:?delete?from?info?where?not?exists?(?select?*?from?infobz?where?info.infid=infobz.infid?)

SQL:?SELECT?A.NUM,?A.NAME,?B.UPD_DATE,?B.PREV_UPD_DATE?FROM?TABLE1,(SELECT?X.NUM,?X.UPD_DATE,?  Y.UPD_DATE?PREV_UPD_DATE?FROM?(SELECT?NUM,?UPD_DATE,?INBOUND_QTY,?STOCK_ONHAND?FROM?TABLE2?WHERE?TO_CHAR(UPD_DATE,'YYYY/MM')?=?TO_CHAR(SYSDATE,?'YYYY/MM'))  ?X,?(SELECT?NUM,?UPD_DATE,?STOCK_ONHAND?FROM?TABLE2?WHERE?TO_CHAR(UPD_DATE,'YYYY/MM')?=?TO_CHAR(TO_DATE(TO_CHAR(SYSDATE,?'YYYY/MM')  ??||?'/01','YYYY/MM/DD')?-?1,?'YYYY/MM')?)?Y,?WHERE?X.NUM?=?Y.NUM?（+）AND?X.INBOUND_QTY?+?NVL(Y.STOCK_ONHAND,0)?  ???X.STOCK_ONHAND?)?B?WHERE?A.NUM?=?B.NUM  ????　　

SQL:?select?*?from?studentinfo?where?not?exists(select?*?from?student?where?studentinfo.id=student.id)?  and?系名稱='"&strdepartmentname&"'?and?專業(yè)名稱='"&strprofessionname&"'?order?by?性別,生源地,高考總成績