|
| |
|
|
gop373
Posts: 35
Joined: 8/28/2004
Status: offline
 |
Max function - 9/27/2004 7:48:46
I have some problem about sql Again!!!
I have the table name aa
id Pricecom1 Pricecom2 Pricecom3 Pricecom4
1 12 54 21 33
2 32 12 31 45
3 33 11 12 22
4 54 44 43 13
5 11 6 100 10
I want to find the maximum number of the button of every column. Form this example it should return 100
I tried
sql="select top 1 * from aaa where (select max(com1,com2,com3)as maxvalue) order by id desc"
but it doesn't work
< Message edited by gop373 -- 9/27/2004 8:32:21 >
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
