-
Select the smallest value in a row of columns
I need a SELECT statement that will return the smallest value per row in a list of columns. For instance:
example table:
---------------------------------
ID | col_1 | col_2 | col_3
---------------------------------
row_1 | 18 | 25 | 30
row_2 | 52 | 73 | 39
row_3 | 24 | 12 | 41
I need a statement that will return me the values 18, 39, 12 in the result set. Can some someone please help.
Thanks,
-2 Peter 3:18
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|