sql统计语句（SQL统计语句）

1. sql语句查询，并统计查询结果数量
2. 如何一条SQL语句就能统计出多个表中某数据的数量
3. 如何写SQL语句按周统计和按季度统计

sql语句查询，并统计查询结果数量

你可以通过两条语句合并一起

如:

select name,age,score from sd_student_t where score > 90

union all

select '合计',null, count(1) from sd_student_t where score > 90

如何一条SQL语句就能统计出多个表中某数据的数量

select count(*) from (select 1 as a from taba union all select 1 as b from tabb ) tabxx

如何写SQL语句按周统计和按季度统计

--sqlserver2005语法统计按周,月,季,年。--按日--select sum(price),day([date]) from table_name where year([date]) ='2006' group by day([date])--按周quarterselect sum(price),datename(week,price_time) from ble_name whereyear(price_time) = '2008' group by datename(week,price_time)--按月select sum(price),month(price_time) from ble_name where year(price_time)= '2008' group by month(price_time)--按季select sum(price),datename(quarter,price_time) from ble_name whereyear(price_time) = '2008' group by datename(quarter,price_time)--按年select sum(price),year(price_time) from ble_name whereyear(price_time) >= '2008' group by year(price_time)

到此，以上就是小编对于SQL统计语句的问题就介绍到这了，希望介绍的3点解答对大家有用，有任何问题和不懂的，欢迎各位老师在评论区讨论，给我留言。