Filtering One column into Different Columns in one statement

0 votes

1 answer

35 views

                          I need to 

SELECT amount FROM table WHERE type='1' AND type='2' AND type'3'

Depending on the types, I need them to be pulled into different columns.

For example,

IF type=1 THEN amount1
IF type=2 THEN amount2
IF type=3 THEN amount3.

Is it possible to this in one statement?

Asked by John (51 rep)

Jul 13, 2016, 03:20 AM
Last activity: Jul 15, 2016, 07:05 AM

Filtering One column into Different Columns in one statement

Related Questions