Reading max of third column along with other column in a group query

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Reading max of third column along with other column in a group query

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-19 : 10:41:14

Jyoti writes "I have a table like the one shown below

col1           col2                       col3
500000.0	26843548781     	26843556030     
10000.0	        26843548781     	26843556028     
10000.0	        26843548781     	26843556029     
10000.0	        26843548902     	26843551712     
150000.0	26843549102     	26843552827     
150000.0	26843549102     	26843552828     
150000.0	26843549102     	26843552829

I want to read value from col2 for each entry in col3(unique)
for maximum value of col 1 in the group of col3.
Thanks in advance
-Jyoti"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources