mencari nilai terbesar dari beberapa field pada tabel
Bismillah
q> Gogling ketemu sumber [link di bawah]
q> menggunakan fungsi greatest
[sourcecode language="sql"]SELECT GREATEST(1, 2, 3,4,5,4,10) from dual[/sourcecode]
sumber:
http://stackoverflow.com/questions/2615697/mysql-biggest-value-from-two-fields
Alhamdulillah
No comments:
Post a Comment