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 |
|
bb888
Starting Member
1 Post |
 Posted - 2010-03-02 : 05:04:49
|
| Please could you tell me the SQL Command to reach the followingThank you very much.OrginalBez Preis VonNr BisNrA 5 1 7B 6 8 12A 5 7 15B 6 12 22B 7 98 103B 7 103 122NewBez Preis VonNr BisNrA 5 1 15B 6 8 22B 7 98 122 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-03-02 : 05:13:29
|
Try this:selectBez,Preis,min(VonNr) as VonNr,max(BisNr) as BisNrfrom tablegroup byBez, Preis
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
SQL Distinct