User contributions for Bacchas
Jump to navigation
Jump to search
- 13:59, 7 November 2017 diff hist +166 TYPES
- 13:53, 7 November 2017 diff hist +31 TYPES →AVG() Returns the Average of Values
- 21:30, 6 November 2017 diff hist +124 CHARACTER BUILT IN FUNCTIONS
- 21:26, 6 November 2017 diff hist +218 CHARACTER BUILT IN FUNCTIONS
- 20:51, 6 November 2017 diff hist +112 CHARACTER BUILT IN FUNCTIONS
- 20:47, 6 November 2017 diff hist +140 CHARACTER BUILT IN FUNCTIONS
- 20:44, 6 November 2017 diff hist +101 CHARACTER BUILT IN FUNCTIONS
- 20:06, 5 November 2017 diff hist +72 Database Queries current
- 20:05, 5 November 2017 diff hist +20 CASE STATEMENT current
- 19:58, 5 November 2017 diff hist +157 CASE STATEMENT
- 19:56, 5 November 2017 diff hist +295 N CASE STATEMENT 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..."
- 19:54, 5 November 2017 diff hist +25 Oracle SQL →FUNCTIONS
- 19:34, 5 November 2017 diff hist 0 DATE BUILT IN FUNCTIONS →ADD_MONTHS() - ADDS MONTHS TO A DATE
- 19:33, 5 November 2017 diff hist +471 N DATE BUILT IN FUNCTIONS Created page with "==MONTHS_BETWEEN() - RETURNS THE NUMBER OF MONTHS BETWEEN 2 DATES== MONTHS_BETWEEN('01-MAR-15','01-JAN-15')=2 ==ADD_MONTHS() - ADDS MONTHS TO A DATE == ADD_MONTHS('01-MAR-1..."
- 19:27, 5 November 2017 diff hist +34 Oracle SQL →FUNCTIONS
- 19:26, 5 November 2017 diff hist +115 CHARACTER BUILT IN FUNCTIONS
- 19:23, 5 November 2017 diff hist +359 N CHARACTER BUILT IN FUNCTIONS Created page with "==UPPER()== UPPER('john') = JOHN ==LOWER()== LOWER('John')=john ==LENGTH()== LENGTH('JOHN')=4 ==SUBSTR()== '''RETURNS PART OF A STRING''' SUBSTR('JAMES',2,3)=AME ==DECODE..."
- 19:17, 5 November 2017 diff hist +39 Oracle SQL →FUNCTIONS
- 19:16, 5 November 2017 diff hist +137 NUMERIC BUILT IN FUNCTIONS
- 19:10, 5 November 2017 diff hist +268 N NUMERIC BUILT IN FUNCTIONS Created page with "==ROUND()== ROUND(49.113212) = 49.11 ==CEIL()== '''Integer value that is greater than or equal to the number''' CEIL(48.99)=49 ==POWER()== POWER(4,2)=16 ==SQRT()== SQR..."
- 19:06, 5 November 2017 diff hist +37 Oracle SQL →FUNCTIONS
- 17:45, 2 November 2017 diff hist +1 Join 3 Tables current
- 22:44, 1 November 2017 diff hist +16 Oracle SQL
- 20:37, 1 November 2017 diff hist +156 Type of Joins ansi and Oracle current
- 20:29, 1 November 2017 diff hist +141 Type of Joins ansi and Oracle
- 20:03, 1 November 2017 diff hist +362 Join 3 Tables
- 19:58, 1 November 2017 diff hist +345 Join 3 Tables
- 19:55, 1 November 2017 diff hist +23 Oracle SQL →Joining Data from multiple Tables
- 19:55, 1 November 2017 diff hist +80 Join 3 Tables
- 19:39, 1 November 2017 diff hist +216 N Join 3 Tables Created page with " SELECT A.sales_date, A.order_id, A.product_id, B.product_name, C.job_title FROM sales A INNER JOIN product B ON A.product_id = B.product_id LEFT OUTER JOIN salesperson C..."
- 19:39, 1 November 2017 diff hist +24 Oracle SQL →Joining Data from multiple Tables
- 19:28, 1 November 2017 diff hist +77 Natural Join current
- 15:28, 1 November 2017 diff hist +171 Outer Joins current
- 14:19, 1 November 2017 diff hist +353 Outer Joins
- 14:11, 1 November 2017 diff hist +221 Outer Joins
- 14:07, 1 November 2017 diff hist +137 Inner Join current
- 14:00, 1 November 2017 diff hist +107 Inner Join
- 13:58, 1 November 2017 diff hist +228 Inner Join
- 13:55, 1 November 2017 diff hist +79 Inner Join
- 13:55, 1 November 2017 diff hist +79 GROUP BY
- 13:54, 1 November 2017 diff hist +156 Inner Join
- 00:24, 1 November 2017 diff hist +282 GROUP BY
- 00:15, 1 November 2017 diff hist +300 GROUP BY →Returns queries in groups
- 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