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 - 2005-08-30 : 07:59:46
|
| Praveen Kumar writes "I have a table look like belowid name--- --------1 joi2 joi3 joi4 kevin5 kevin6 kevin7 kevinif i use a value 2 in the query, i need to get the table look like belowid name---- -------1 joi2 joi4 kevin5 kevinplease help me to write a query for the above question " |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-08-30 : 08:54:32
|
| you need to explain your logic as well -- your results don't make much sense just by looking at them. |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-08-30 : 09:02:51
|
| "you need to explain your logic as well -- your results don't make much sense just by looking at them."...top 2 from each group (by name)??? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-08-30 : 09:04:47
|
quote:
Originally posted by AndrewMurphy
"you need to explain your logic as well -- your results don't make much sense just by looking at them."...top 2 from each group (by name)???
Yes. It is  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Help for a Query