❶ sql如何建立二維統計表
select
AM_ID,
SUM(case when LOB='SP' then 1 ELSE 0 END) AS SP,
SUM(case when LOB='ENT' then 1 ELSE 0 END) AS ENT,
SUM(case when LOB='PS' then 1 ELSE 0 END) AS PS,
SUM(case when LOB='Midmarket' then 1 ELSE 0 END) AS Midmarket
from TestTable
group by AM_ID
❷ 請教一個SQL查詢二維表
樓上說的和我導師講的不同誒
我們導師說只要是關系型資料庫，一個關系就是一張二維表，表中的行稱為元組，表中的列稱為屬性。
什麼是關系型資料庫呢？就是這個資料庫以關系模型為基礎。
❸ 請教大家幫忙寫一個SQL查詢得到二維數據
select t.address,
sum(case when t.type = '搶劫' then 1 else 0 end) sum1,
sum(case when t.type = '盜竊' then 1 else 0 end) sum2
from test t where t.address in ('"+addrss+"')
and t.type in ('"+type+"')
❹ 請教 sql 二維表 查詢語句
b.[代碼] + '/' + c.[代碼]) as [代碼]
,(a.[名稱] + '/' + b.[名稱] + '/' + c.[名稱]) as [名稱]
FROM xzqh as a,xzqh as b,xzqh as c
WHERE a.代碼 = LEFT(b.代碼,1)
and b.代碼 = left(c.代碼,3)
and LEN(b.代碼) = 3
and LEN(c.代碼) = 5
不過有點疑問的是一級超過10以後你是怎麼定義的？得看你的定義調整語句了
代碼如果是整型得轉換成字元