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 |
|
mary_itohan
Posting Yak Master
191 Posts |
 Posted - 2008-10-05 : 05:25:22
|
Hello,how do i get the highest value in my column called usercount ?select top 1 usercount from history where batch = 861 Its a column contaning numbers from 1 to ....Thanks_____________________Yes O ! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-05 : 05:38:49
|
| two ways1.select top 1 usercount from history where batch = 861 order by usercount desc2.select max(usercount) from history where batch = 861 |
 |
|
|
mary_itohan
Posting Yak Master
191 Posts |
Posted - 2008-10-05 : 05:41:48
|
| silly meThank you_____________________Yes O ! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-05 : 05:44:23
|
quote:
Originally posted by mary_itohan
silly meThank you_____________________Yes O !
no worriesyou're always welcome  |
|
|
|
|
|
|
How do i get the highest value ?