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 |
|
kote_alex
Posting Yak Master
112 Posts |
 Posted - 2009-10-16 : 09:27:24
|
| select distinct x,count(x),cash from xxx group by x ,cash having count(x)='1' order by x,cashI just want to select the distinct entries with the distinct cash payment to the distinct client nb.Any ideas ?Thanks ! |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-16 : 09:31:52
|
And what is the problem?Sample data?Wanted output?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
kote_alex
Posting Yak Master
112 Posts |
Posted - 2009-10-16 : 09:38:00
|
| wanted data ... i can't select what the distinct columns together x distinct , cash distinct ... |
|
|
|
kote_alex
Posting Yak Master
112 Posts |
Posted - 2009-10-16 : 10:18:15
|
| bump |
|
|
|
kote_alex
Posting Yak Master
112 Posts |
Posted - 2009-10-17 : 02:24:56
|
| nobody ? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-10-17 : 02:31:01
|
kote,We need to know what do you want. Show us your sample data and expected outputquote:
Originally posted by webfred
And what is the problem?Sample data?Wanted output?
No, you're never too old to Yak'n'Roll if you're too young to die.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
select distinct number with other column