¹¦ÄÜÇ¿´óµÄSQLÓï¾ä

1. ¸´ÖƱí½á¹¹
Sql´úÂë
   1. select * into B from A where 1=0;   
select * into B from A where 1=0;
 2.¸´ÖƱí¼Ç¼ ¸´ÖÆijЩ×Ö¶Î
Sql´úÂë
   1. insert into B(a, b, c) select d, e, f from A;   
insert into B(a, b, c) select d, e, f from A;
  ¸´ÖÆÕû¸ö±í¼Ç¼
Sql´úÂë
   1. insert into B select * from A;   
insert into B select * from A;
3.ÍâÁ¬½Ó²éѯ
Sql´úÂë
   1. select A.a, A.b, A.c, B.c, B.d, B.f from A LEFT OUT JOIN B ON A.a = B.c; ¡¡  
select A.a, A.b, A.c, B.c, B.d, B.f from A LEFT OUT JOIN B ON A.a = B.c; ¡¡
4.È¡Ìض¨Ê±¼äÄÚµÄÊý¾Ý
Sql´úÂë
   1. select * from A where datediff("minute", ¿ªÊ¼Ê±¼ä×Ö¶Î, getdate())>ʱ¼ä²î ¡¡  
select * from A where datediff("minute", ¿ªÊ¼Ê±¼ä×Ö¶Î, getdate())>ʱ¼ä²î ¡¡
5.Á½ÕŹØÁª±í£¬É¾³ýÖ÷±íÖÐÒѾ­ÔÚ¸±±íÖÐûÓеÄÐÅÏ¢
Sql´úÂë
   1. delete from A where not exists(select ID from B where A.infid=B.infid );  
delete from A where not exists(select ID from B where A.infid=B.infid );
6. ¸´ÔӵĶ༶Ìõ¼þ²éѯ
Sql´úÂë
   1. SELECT A.NUM, A.NAME, B.UPD_DATE, B.PREV_UPD_DATE   
   2.      from TABLE1,(SELECT X.NUM, X.UPD_DATE, Y.UPD_DATE PREV_UPD_DATE   
   3.                   from (SELECT NUM, UPD_DATE, INBOUND_QTY, STOCK_ONHAND   
   4.                         from TABLE2   
   5.                         WHERE TO_CHAR(UPD_DATE,’’YYYY/MM’’) =   
   6.         &nb