CASE STATEMENT - Revision history

Bacchas at 20:05, 5 November 2017

2017-11-05T20:05:04Z

← Older revision		Revision as of 20:05, 5 November 2017
Line 6:		Line 6:
	WHEN TOTAL_AMOUNT < 1000 THEN 'MEDIUM'		WHEN TOTAL_AMOUNT < 1000 THEN 'MEDIUM'
	ELSE 'HEIGH'		ELSE 'HEIGH'
	END		END AS "AMOUNT BRACKET"
	FROM SALES;		FROM SALES;

	[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 19:58, 5 November 2017

2017-11-05T19:58:20Z

← Older revision		Revision as of 19:58, 5 November 2017
Line 1:		Line 1:
	==THE CASE STATEMENT EVALUATES A SINGLE EXPRESSION AND COMPARES IT AGAINST SEVERAL POTENTIAL VALUES, OR EVALUATES MULTIPLE BOOLEAN EXPRESSIONS AND CHOOSES THE FIRST ONE THANT IS TRUE. THIS IS EQUAL TO IF THEN ELSE ==		==THE CASE STATEMENT==
			''' EVALUATES A SINGLE EXPRESSION AND COMPARES IT AGAINST SEVERAL POTENTIAL VALUES, OR EVALUATES MULTIPLE BOOLEAN EXPRESSIONS AND CHOOSES THE FIRST ONE THANT IS TRUE. THIS IS EQUAL TO IF THEN ELSE '''
			SELECT ORDER_ID, TOTAL_AMOUNT,
			CASE
			WHEN TOTAL_AMOUNT <= 100 THEN 'LOW'
			WHEN TOTAL_AMOUNT < 1000 THEN 'MEDIUM'
			ELSE 'HEIGH'
			END
			FROM SALES;

	[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas: Created page with "==THE CASE STATEMENT EVALUATES A SINGLE EXPRESSION AND COMPARES IT AGAINST SEVERAL POTENTIAL VALUES, OR EVALUATES MULTIPLE BOOLEAN EXPRESSIONS AND CHOOSES THE FIRST ONE THANT..."

2017-11-05T19:56:42Z

Created page with "==THE CASE STATEMENT EVALUATES A SINGLE EXPRESSION AND COMPARES IT AGAINST SEVERAL POTENTIAL VALUES, OR EVALUATES MULTIPLE BOOLEAN EXPRESSIONS AND CHOOSES THE FIRST ONE THANT..."

New page

==THE CASE STATEMENT EVALUATES A SINGLE EXPRESSION AND COMPARES IT AGAINST SEVERAL POTENTIAL VALUES, OR EVALUATES MULTIPLE BOOLEAN EXPRESSIONS AND CHOOSES THE FIRST ONE THANT IS TRUE. THIS IS EQUAL TO IF THEN ELSE ==

[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]]