lachlanpearce
Last Activity: Dec 29 '11, 04:05 AM
Joined: Dec 22 '11
Location:
-
Hi, I tried the example but it still didn't work. Can you write a specific example for this question? -
Can you give me an example using the tables in the first post.Leave a comment:
-
GROUP BY troubles
Hi, I'm trying to write a Group By query.
I have a table that looks like this:
I want to GROUP BY label using a MAX aggregate function...Code:[B][U]label value version[/U][/B] Fee 25.99 5795 Term 3 5795 Terminated 0 5562 Terminated 1 5563 Terminated 0 5794 Terminated 0 5795
-
Choosing to select a column based on null values
Hi,
I have a table with these values:
I want to write a select query that will select either column2 or column3 based on whether column 3 is not null and output something like this:Code:========================================= column1 column2 column3 firstname 462 david lastname smith NULL =========================================
...Code:
No activity results to display
Leave a comment: