如何在单个查询sqlserver中使用Distinct,where,groupby,orderby [英] how to use Distinct, where, groupby,orderby in single query sqlserver
本文介绍了如何在单个查询sqlserver中使用Distinct,where,groupby,orderby的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
hello frnds,
我想在sqlserver 2005中的单个查询中使用Distinct,where,groupby和orderby。
请帮帮我。谢谢。
hello frnds,
I want to use Distinct, where , groupby and orderby in single query in sqlserver 2005.
Please can you help me. thanks.
推荐答案
尝试像
Try Something like
Select Distinct (ColumnName)
from TableName
where ColumnName > 1 //Change the Condition
group by ColumnName
order by ColumnName Desc
你可以这样使用.......
选择不同的列名,........
来自tablename
where .....
group by ... 。
by columnname desc / asc
u can use like this.......
select distinct columnname,........
from tablename
where.....
group by....
order by columnname desc/asc
这篇关于如何在单个查询sqlserver中使用Distinct,where,groupby,orderby的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文