hi
its somthing u have 4 or more values u have to choose the maximum value out of it.
eg : to choose maximum value out of colum ( select max(xxx) from table group by xxx )
the same way maximum of single row.
jkshetty
Last Activity: Nov 17 '07, 04:14 AM
Joined: Oct 21 '07
Location:
-
yes i want to update the max value of each row?
each rows high...Leave a comment:
-
get max values
co_1 col_2 co_3 result
12.00 11.00 21.00
11.00 23.00 43.00
22.00 23.00 43.00
22.00 43.00 23.00
sql query to update RESULT with max of (co_1 , col_2 , col_3) -
how to get max value of multiple rows ???
eg :
product amt1 amt2 amt3 amt4
a 100 200 150 170
b 120 33 54 94
the max amt is : "200" for product a
the max amt is : "120" for product a
pls get me SQL Query. -
sql
hi
pls get me SQL Formula
i want to round this figure.
eg :
if 1244.44 it should be - 1244.40
545.58 it should be - 545.55
477.66 it should be - 477.65
350.55 it should be - 350.55 -
filter data - SQL
Table :
Name Month Marks
A Sept 150
B Sept 200
C Sept 100
D Sept 500
A Oct 100
B Oct 225
C Oct 300
D Oct 115
Query
-----
Select only those students where students score more marks than previous month....
No activity results to display
Leave a comment: