Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vineela
Starting Member
1 Post |
 Posted - 2004-07-06 : 11:08:58
|
| Hi All, I have a question on how to get the count of a particular query.I have a table(Student) with the following colums:say a,b,c,d,ePrimary Key is on a and b columns.The query i want to execute is select distinct a, a+'-'+c,d from student order by d,aNow, my question is How to get the count of the above queryPls suggest a query which returns the count of the above caseRegardsVineela |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-07-06 : 11:49:33
|
| Declare @myCount intSelect @myCount = count(*) From (Select distinct a, c, d From student) as ACorey |
 |
|
|
|
|
|
Question on count