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 |
|
ind_sql
Starting Member
16 Posts |
 Posted - 2004-09-23 : 16:51:43
|
| i don't need only the emplid and max sequence....your query works fine if it is only for two coloumns....the problem is i need all the data..... distinct emplid, age sex corresponding to the max sequence number. IF i group by coloumn 1 i get correct results for emplid and max sequence but not for sex....e.g the sex should be male, mal , fem in the three cases respectivelyhelp me |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-09-23 : 16:54:56
|
| I can't help you get Sex.Brett8-) |
 |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-09-23 : 16:57:14
|
well you could... if you lived close by...  Corey |
|
|
|
ind_sql
Starting Member
16 Posts |
Posted - 2004-09-23 : 17:20:25
|
| later guys first lets get this query solved.....:) |
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-09-23 : 17:22:10
|
hehehe  Corey |
|
|
|
|
|
|
its not the correct solution