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 |
|
Swede
Yak Posting Veteran
74 Posts |
 Posted - 2002-01-24 : 08:17:59
|
| In a SELECT query I want to get the highest integer stored in one table field. How do I do that most easily?=====================================Why not try and do the impossible? |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-01-24 : 08:22:44
|
| SELECT MAX(fld) FROM table-------------------If trainstation is a place where train stops, what's a workstation? |
 |
|
|
Swede
Yak Posting Veteran
74 Posts |
Posted - 2002-01-24 : 08:23:26
|
| Thanks! I take it I can do this on a joined query as well right?=====================================Why not try and do the impossible? |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-24 : 08:24:48
|
| Yeah you can.--------------------------------------------------------------Dont Tell God how big your Problem is , Tell the Problem how Big your God is |
|
|
|
Swede
Yak Posting Veteran
74 Posts |
Posted - 2002-01-24 : 08:26:41
|
| Great, thanks :)Am working on this developers area, and need to have different user levels. including user groups, user innate level and so forth...Thanks guys=====================================Why not try and do the impossible? |
|
|
|
|
|
|
Selecting highest integer