Search results

Page title matches

• Invalid Group function
  <div class = "link e-oracle">ORA-00934: group function is not allowed here</div> Invalid use of group function</div> ...
  2 KB (265 words) - 13:20, 9 August 2012
• No Group By Function
  <div class = "link e-oracle">ORA-00937: not a single-group group function</div> <div class = "link e-sqlite">ORA-00937: not a single-group group function</div> ...
  1 KB (220 words) - 13:20, 9 August 2012

Page text matches

• SQL Error Messages
  <li>[[Invalid Group function |Error 1111 Invalid use of group function]]</li> <li>[[No Group By Function |Error 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP ...
  3 KB (463 words) - 11:18, 19 July 2012
• Window LAG
  ==Window Function== ==Introducing the LAG function== ...
  8 KB (1,432 words) - 20:03, 26 February 2023
• YEAR
  <li>[[EXTRACT |EXTRACT function]]</li> <li>[[%2B(dates) |+(date) function]]</li> ...
  2 KB (257 words) - 21:38, 21 October 2012
• QUARTER
  <li>[[EXTRACT |EXTRACT function]]</li> <li>[[%2B(dates) |+(date) function]]</li> ...
  2 KB (389 words) - 21:25, 21 October 2012
• TO CHAR(dates)
  <li>[[EXTRACT |EXTRACT function]]</li> <li>[[%2B(dates) |+(date) function]]</li> ...
  2 KB (319 words) - 15:28, 16 July 2012
• DAY
  <li>[[EXTRACT |EXTRACT function]]</li> <li>[[%2B(dates) |+(date) function]]</li> ...
  2 KB (270 words) - 18:02, 21 October 2012
• MINUTE
  <li>[[EXTRACT |EXTRACT function]]</li> <li>[[%2B(dates) |+(date) function]]</li> ...
  2 KB (270 words) - 21:12, 21 October 2012
• HOUR
  <li>[[EXTRACT |EXTRACT function]]</li> <li>[[%2B(dates) |+(date) function]]</li> ...
  2 KB (271 words) - 21:06, 21 October 2012
• MONTH
  <li>[[EXTRACT |EXTRACT function]]</li> <li>[[%2B(dates) |+(date) function]]</li> ...
  1 KB (252 words) - 21:24, 21 October 2012
• SECOND
  <li>[[EXTRACT |EXTRACT function]]</li> <li>[[%2B(dates) |+(date) function]]</li> ...
  2 KB (252 words) - 21:36, 21 October 2012
• No Group By Function
  <div class = "link e-oracle">ORA-00937: not a single-group group function</div> <div class = "link e-sqlite">ORA-00937: not a single-group group function</div> ...
  1 KB (220 words) - 13:20, 9 August 2012
• DAY/de
  <li>[[EXTRACT/de | EXTRACT function]]</li> <li>[[%2B(dates)/de | +(date) function]]</li> ...
  2 KB (285 words) - 18:06, 21 October 2012
• Format a date and time
  The Standard provides us with the EXTRACT function that can be ...rary/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp">CONVERT</a> function may be used. ...
  24 KB (4,154 words) - 11:02, 8 August 2012
• AVG
  <p>AVG is an aggregate function it is normally used with GROUP BY.</p> <li>[[MAX |MAX function]]</li> ...
  1 KB (245 words) - 16:54, 8 September 2012
• COUNT
  <p>COUNT is an aggregate function it is normally used with GROUP BY. </p> <li>[[AVG |AVG function]]</li> ...
  1 KB (213 words) - 10:32, 1 October 2012
• TRIM
  This function is particularly useful when working with CHAR fields. <li>[[SUBSTRING |SUBSTRING function]]</li> ...
  1 KB (207 words) - 15:29, 16 July 2012
• YYYYMMDD date format
  The SQL standard gives us the EXTRACT function to get year, month and day. We can use the LPAD function to pad these numbers to 2 digits. ...
  2 KB (359 words) - 15:37, 17 July 2012
• Invalid Group function
  <div class = "link e-oracle">ORA-00934: group function is not allowed here</div> Invalid use of group function</div> ...
  2 KB (265 words) - 13:20, 9 August 2012
• Incorrect GROUP BY
  ...">Error 7 ERROR: Attribute xxx.xxx must be GROUPed or used in an aggregate function</div> ...it is in a SELECT clause, HAVING clause, or ORDER BY clause with a column function and no GROUP BY clause is specified. SQLSTATE=42803</div> ...
  2 KB (333 words) - 13:15, 9 August 2012
• SELECT from WORLD Tutorial
  ...countries of the <code>continent</code> 'South America'. Use the [[ROUND]] function to show the values to two decimal places. *You can use the [[LENGTH]] function to find the number of characters in a string ...
  9 KB (1,406 words) - 20:24, 25 September 2023