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 |
|
brubaker
Starting Member
15 Posts |
 Posted - 2001-11-20 : 21:14:38
|
| The following code was the published answer to to Reader Challenge #2:select g1.Player, g1.hcap, Rank = (select count(*) + 1 from SQLTeam_Golfers g2 where g1.hcap < g2.hcap)from SQLTeam_Golfers g1order by RankMy question is how can you accomplish this same task if the table SQLTeam_Golfers is a derived table? I could put the same code for the derived table in both places and then alias them both, but I would really like a more elegant solution. Any ideas? |
|
|
|
|
|
Question about Reader Challenge #2