就2次查詢.. SELECT AA,BB,SUM(DD) FROM ( SELECT AA,BB,CC,DD from table GROUP BY `A...
不能~登入資料庫就要帳密~除非你怕有洩密吧.. 除非你要先暫停MSSQL服務~直接複製資料庫到指定路徑~再恢復MSSQL服務..
這樣? select * from a where typeid='助理' and dept <> '' 或是.. select * from...
用union all後面欄位不足的用null補足 select * from (( SELECT A.WORK_ORDER ,A.PALLET_NO ,A...
select * from (( select col_A, sum(col_B) from table where col_B > 0 grou...
declare @tab table( partnum nvarchar(50) ,a nvarchar(50) ,AM01 int ,AM02 int...
把公司的xxxxxx@wifi.hinet.net改成xxxxxx@hinet.net就可以撥接換IP了
就放在order by case 欄位 when 'A' then 4 when 'B' then 8 when 'C' then 12 else 0 end