TYPES - Revision history

Bacchas: /* COUNT() Returns the number or rows */

2017-11-07T21:12:26Z

COUNT() Returns the number or rows

← Older revision		Revision as of 21:12, 7 November 2017
Line 21:		Line 21:

	==COUNT() Returns the number or rows ==		==COUNT() Returns the number or rows ==
			''' Returns the record count'''
	SELECT COUNT(*) FROM SALES		SELECT COUNT(*) FROM SALES
	''' ~~Returns the record count~~'''
			'''Count all orders not yet shipped'''
			SELECT COUNT(*) "ORDERS NOT SHIPPED"
			FROM orders
			WHERE shipdate IS NULL;

	==VARIANCE ==		==VARIANCE ==

Bacchas: /* SUM() Returns the sum of values */

2017-11-07T20:10:46Z

SUM() Returns the sum of values

← Older revision		Revision as of 20:10, 7 November 2017
Line 9:		Line 9:

	==SUM() Returns the sum of values ==		==SUM() Returns the sum of values ==
			'''Returns the count in one column and the sum of the total_amount column'''
	SELECT COUNT(*), SUM(TOTAL_AMOUNT) from sales;		SELECT COUNT(*), SUM(TOTAL_AMOUNT) from sales;
	~~'''Returns the count in one column and the~~ sum ~~of the total_amount column'''~~
			SELECT sum((paideach-cost)*quantity) "Total Profit"
			FROM orderitems JOIN books USING (isbn)
			WHERE order# = 1007

	==AVG() Returns the Average of Values ==		==AVG() Returns the Average of Values ==

Bacchas at 13:59, 7 November 2017

2017-11-07T13:59:22Z

← Older revision		Revision as of 13:59, 7 November 2017
Line 4:		Line 4:

	==MAX() Returns the largest Value ==		==MAX() Returns the largest Value ==
			'''Ignores Null values'''
			SELECT MAX(customer#)
			FROM orders;

	==SUM() Returns the sum of values ==		==SUM() Returns the sum of values ==
Line 16:		Line 19:
	SELECT COUNT(*) FROM SALES		SELECT COUNT(*) FROM SALES
	''' Returns the record count'''		''' Returns the record count'''

			==VARIANCE ==
			'''Returns the variance - ignores NULL values'''
			SELECT VARIANCE(retail)
			FROM books;


	==FIRST() Returns the first value of the group==		==FIRST() Returns the first value of the group==

Bacchas: /* AVG() Returns the Average of Values */

2017-11-07T13:53:24Z

AVG() Returns the Average of Values

← Older revision		Revision as of 13:53, 7 November 2017
Line 10:		Line 10:

	==AVG() Returns the Average of Values ==		==AVG() Returns the Average of Values ==
			SELECT AVG(cost)
			FROM books;

	==COUNT() Returns the number or rows ==		==COUNT() Returns the number or rows ==

Bacchas at 23:55, 31 October 2017

2017-10-31T23:55:38Z

← Older revision		Revision as of 23:55, 31 October 2017
Line 18:		Line 18:

	==LAST() Returns the last value of the group==		==LAST() Returns the last value of the group==

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

Bacchas at 23:54, 31 October 2017

2017-10-31T23:54:47Z

← Older revision		Revision as of 23:54, 31 October 2017
Line 1:		Line 1:
	==MIN()Returns the smallest Value==		==MIN()Returns the smallest Value==
			SELECT COUNT(*), SUM(TOTAL_AMOUNT), MIN(TOTAL_AMOUNT) from sales;
			'''Returns the count in one column, the sum of the total_amount column and Min amount'''

	==MAX() Returns the largest Value ==		==MAX() Returns the largest Value ==

	==SUM() Returns the sum of values ==		==SUM() Returns the sum of values ==
			SELECT COUNT(*), SUM(TOTAL_AMOUNT) from sales;
			'''Returns the count in one column and the sum of the total_amount column'''

	==AVG() Returns the Average of Values ==		==AVG() Returns the Average of Values ==

	==COUNT() Returns the number or rows ==		==COUNT() Returns the number or rows ==
			SELECT COUNT(*) FROM SALES
			''' Returns the record count'''

	==FIRST() Returns the first value of the group==		==FIRST() Returns the first value of the group==

	==LAST() Returns the last value of the group==		==LAST() Returns the last value of the group==

Bacchas: Created page with "==MIN()Returns the smallest Value== ==MAX() Returns the largest Value == ==SUM() Returns the sum of values == ==AVG() Returns the Average of Values == ==COUNT() Returns th..."

2017-10-31T23:45:53Z

Created page with "==MIN()Returns the smallest Value== ==MAX() Returns the largest Value == ==SUM() Returns the sum of values == ==AVG() Returns the Average of Values == ==COUNT() Returns th..."

New page

==MIN()Returns the smallest Value==

==MAX() Returns the largest Value ==

==SUM() Returns the sum of values ==

==AVG() Returns the Average of Values ==

==COUNT() Returns the number or rows ==

==FIRST() Returns the first value of the group==

==LAST() Returns the last value of the group==