User contributions for Bacchas
Jump to navigation
Jump to search
- 00:07, 1 November 2017 diff hist +214 N GROUP BY Created page with "== Returns queries in groups == SELECT SALES_DATE, SUM(TOTAL_AMOUNT) FROM SALES GROUP BY SALES_DATE; ''' This will take the sales made on the dates add them and return a c..."
- 00:05, 1 November 2017 diff hist +42 Oracle SQL
- 23:55, 31 October 2017 diff hist +79 TYPES
- 23:54, 31 October 2017 diff hist +341 TYPES
- 23:45, 31 October 2017 diff hist +292 N TYPES 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..."
- 23:42, 31 October 2017 diff hist +54 Oracle SQL
- 21:10, 31 October 2017 diff hist +365 Set Operators →MINUS current
- 21:03, 31 October 2017 diff hist +1 Set Operators →INTERSECT
- 21:02, 31 October 2017 diff hist +208 Set Operators →INTERSECT
- 16:32, 31 October 2017 diff hist +53 Database Queries →Select all tables owned by the user
- 16:28, 31 October 2017 diff hist +65 Database Queries
- 19:26, 27 October 2017 diff hist −16 Table Creation and Management
- 16:59, 27 October 2017 diff hist +349 Insert Command current
- 23:21, 26 October 2017 diff hist +4 Table Creation and Management →Creating NEW Tables
- 23:21, 26 October 2017 diff hist −2 Table Creation and Management →Creating NEW Tables
- 23:21, 26 October 2017 diff hist +3 Table Creation and Management →Creating NEW Tables
- 23:20, 26 October 2017 diff hist +357 Table Creation and Management →Creating NEW Tables
- 23:16, 25 October 2017 diff hist +72 Set Operators →MINUS
- 23:14, 25 October 2017 diff hist +18 Oracle SQL →Set Operators
- 23:02, 25 October 2017 diff hist +154 Outer Joins →Outer Joins: JOIN Method
- 22:54, 25 October 2017 diff hist +75 Type of Joins ansi and Oracle
- 22:52, 25 October 2017 diff hist +116 N Type of Joins ansi and Oracle Created page with "Ansi * Cross Join * Natural Join (equijoin) * Join Using (col, col); * Join ON () eg x=y Oracle * Cartesian Product"
- 22:45, 25 October 2017 diff hist +5 Oracle SQL →Type of Joins ansi and Oracle
- 22:45, 25 October 2017 diff hist +37 Oracle SQL →Joining Data from multiple Tables
- 22:44, 25 October 2017 diff hist +1 Oracle SQL →Natural Join
- 22:06, 25 October 2017 diff hist +1 BETWEEN AND Operator current
- 01:11, 25 October 2017 diff hist +93 N Inner Join Created page with "'''A join of two or more tables that returns only the matched rows is called an inner join'''"
- 01:07, 25 October 2017 diff hist +21 Oracle SQL →Joining Data from multiple Tables
- 01:01, 25 October 2017 diff hist −14 Oracle SQL →Joining Data from multiple Tables
- 01:00, 25 October 2017 diff hist +16 Oracle SQL →Joining Data from multiple Tables
- 00:59, 25 October 2017 diff hist +21 Oracle SQL →Cartesian Join or Cross Join
- 00:59, 25 October 2017 diff hist −10 Oracle SQL →Non-Equality Joins ON CLAUSE
- 00:58, 25 October 2017 diff hist −13 Oracle SQL →Equality Joins USING CLAUSE
- 00:58, 25 October 2017 diff hist +11 Oracle SQL →Non-Equality Joins
- 00:53, 25 October 2017 diff hist +14 Oracle SQL →Equality Joins
- 00:50, 25 October 2017 diff hist +105 Cartesian Join or Cross Join current
- 00:46, 25 October 2017 diff hist +466 N Natural Join Created page with "A natural join is based on all columns in two tables that have the same name and selects rows from the two tables that have equal values in all matched columns SELECT first_..."
- 00:39, 25 October 2017 diff hist +23 Oracle SQL →Joining Data from multiple Tables
- 20:17, 24 October 2017 diff hist +128 LOGICAL Operators current
- 20:15, 24 October 2017 diff hist +135 ORDER BY Clause current
- 20:12, 24 October 2017 diff hist +102 ORDER BY Clause
- 20:11, 24 October 2017 diff hist +387 ORDER BY Clause
- 20:01, 24 October 2017 diff hist +403 N ORDER BY Clause Created page with " *When sorting in ascending order, values are listed in this order: 1. Blank and special characters 2. Numeric values 3. Character values (uppercase first) 4. NULL values * Un..."
- 19:59, 24 October 2017 diff hist −2 Oracle SQL →[ORDER BY Clause]
- 19:59, 24 October 2017 diff hist +28 Oracle SQL →Restricting Rows and Sorting Data
- 19:58, 24 October 2017 diff hist +312 N NULL Operator Created page with "If you need to identify records that have a NULL value, you must use the IS NULL comparison operator SELECT order#, shipdate FROM orders WHERE shipdate IS NULL; SELECT o..." current
- 19:55, 24 October 2017 diff hist +24 Oracle SQL →Restricting Rows and Sorting Data
- 19:55, 24 October 2017 diff hist +85 LOGICAL Operators
- 19:48, 24 October 2017 diff hist +248 LOGICAL Operators
- 19:46, 24 October 2017 diff hist +915 N LOGICAL Operators Created page with "At times, you need to search for records based on two or more conditions. In these situations, you can use logical operators to combine search conditions. The logical operator..."