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 |
|
ajmaly
Starting Member
11 Posts |
 Posted - 2010-07-26 : 12:05:39
|
| Below is the main tbleOriginal table,key Name Order1 A1 11 A2 2 1 A3 32 B1 1 2 B2 22 B3 3Need to select records for order #1 and order #2 from each set, i.e, Output table shold be,key Name Order1 A1 11 A2 2 2 B1 1 2 B2 2Please help me writing query? ajmal |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
need help in query