如何在sql server中查找表中的总列数 [英] how to find total number of columns in a table in sql server

问题描述

大家好



这里我对此查询有疑问我想要总列数，

我的查询：

 选择  distinct  rd.UserID，sm.EmpNameC，（ select  count（UserId）来自 RawData  where  TimeEntry   '  06 / Nov / 2014 09:00:00 AM' 和 '  06 / Nov / 2014 10:00:00 AM'） as  '  BreakFast' 来自 RawData   rd  inner   join  StaffMaster  as  sm  on  rd.UserID = sm.UserIdN 

输出喜欢：



BreakFast

0

0

0

0

像这样我想要这个专栏的总和，做什么....

解决方案

< blockquote>

 选择非重复计数（UserId）
 来自 RawData 
 其中 '  06 / Nov /之间的TimeEntry 2014 09:00:00 AM' 
和'  06 / Nov / 2014 10:00 ：00 AM'） as  '  BreakFast ' 
 来自 RawData  as  rd 
 inner 加入 StaffMas ter  as  sm 
 on rd.UserID = sm.UserIdN 

试试这个：

 选择 * from（ select  < span class =code-keyword> distinct  rd.UserID，sm.EmpNameC  from  RawData  as  rd  inner   join  StaffMaster  as  sm  on  rd.UserID = sm.UserIdN）t1  inner   join  
（选择 count（UserId），userId 来自 RawData 其中 TimeEntry   '  06 / Nov / 2014 09:00:00 AM' 和 '  06 / Nov / 2014 10:00:00 AM'  group   by  userId）t2  on  t1.userId = t2.userId 

语法为：

 选择 * from（ select  userId，name  from  table1） t1 内部  join （ select  count（userid ），名称来自 table2）t2  on  t1.userId = t2.userId 

hi All

Here i have problem with this query i want total number of columns,
My Query:

select distinct rd.UserID,sm.EmpNameC,(select count(UserId) from RawData where TimeEntry between '06/Nov/2014 09:00:00 AM' and '06/Nov/2014 10:00:00 AM') as 'BreakFast' from RawData as rd inner join  StaffMaster as sm on rd.UserID=sm.UserIdN

Output Like:

BreakFast
0
0
0
0
like this i want total sum of this column, what to do....

解决方案

select distinct count(UserId) 
from RawData 
where TimeEntry between '06/Nov/2014 09:00:00 AM' 
and '06/Nov/2014 10:00:00 AM') as 'BreakFast'
from RawData as rd 
inner join  StaffMaster as sm 
on rd.UserID=sm.UserIdN

try this:

select *from ( select distinct rd.UserID,sm.EmpNameC from RawData as rd inner join  StaffMaster as sm on rd.UserID=sm.UserIdN) t1 inner join
 (select count(UserId),userId from RawData where TimeEntry between '06/Nov/2014 09:00:00 AM' and '06/Nov/2014 10:00:00 AM' group by userId) t2 on t1.userId=t2.userId

The Syntax is :

select *from (select userId,name from table1)t1 inner join (select count(userid),name from table2)t2 on t1.userId=t2.userId

这篇关于如何在sql server中查找表中的总列数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！