sql常用語句匯總-在線瀏覽
2024-09-03 10:02本頁面
【正文】 view_name按組查詢：(當(dāng)有統(tǒng)計(jì)函數(shù)，普通字段) FROM wdc_ts_code 創(chuàng)建視圖： right(字段,位數(shù)) = 39。/left(字段,位數(shù)) = 39。空字段 CREATE TABLE [dbo].[uploadFiles1] [id] [int] IDENTITY (1, 1) NOT NULL, ) ON [PRIMARY] CREATE TABLE [dbo].[uploadFiles1] [id] [int] IDENTITY (1, 1) NOT NULL primary key 批量更新，多表鏈接 SET status = 39。 (SELECT MAX(id) AS id, A0100 FROM A004A001 GROUP BY A0100) AS b ON = AND = 參數(shù)聲明Select MaxId=+ dr[Cx_MainID].ToString() +。 (strSql=declare MaxId int。) select * into b from a where id1復(fù)制表(新增)：顯示多表信息(不關(guān)聯(lián))：顯示文章、提交人和最后回復(fù)時(shí)間 (select max(adddate) adddate from table where =) b顯示多表信息(關(guān)聯(lián))： select name,sex,(select from b where =) as age from a清理多表信息(關(guān)聯(lián))：刪除主表中已經(jīng)在副表中沒有的信息 SELECT (CASE WHEN EXISTS(SELECT * FROM Handle b WHERE = 1) THEN MIN(HandleID) + 1 ELSE 1 END) as HandleID FROM Handle WHERE NOT HandleID IN (SELECT 1 FROM Handle a)000039。 FROM pub_userLogin一個(gè)表中的數(shù)據(jù)是否在另一集合中 (子查詢) 查詢的是集合 查詢的是一條記錄where 兩表：select [] from [表名1] inner join [表名2] on [] = [] select SCOTT.web_tbl_login.LOGINID, SCOTT.wdc_ts_code.CODE, from SCOTT.web_tbl_login , where SCOTT.web_tbl_login.BUILDUNITID = SCOTT.wdc_ts_code.code and SCOTT.wdc_ts_code.codeid = 39。 union SCOTT.web_tbl_login.REALNAME,00039。 SCOTT.web_tbl_login.BUILDUNITID, where SCOTT.web_tbl_login.STATION = 39。 select
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1