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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-23 : 10:34:50
|
| Ric Moore writes "I'm building a football game that has a league table. I wish to return ten rows from the table, ordered by the team rank in the league. That's easy enough.However, the ten rows I want to display have the users team in the middle so the 4 teams rank higher are display and so are the 5 teams below.(HTML table deleted)Can such a query be done in 1 line of SQL?" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-05-23 : 10:34:50
|
| Search for an article titled "What's After TOP". |
 |
|
|
|
|
|
How do you select a mid set of rows from table?