Tags » GROUP BY

Subqueries with Like, count, group by

My table:

 +----+------------+-------+-------+
 | id |    Name    |  Type |  Code |
 +----+------------+-------+-------+
 |  1 | /Color     | black | cod-1 |
 |  2 | Colorless  | black | cod-2 |
 |  3 | Colorful   | black | cod-1 |
 |  4 | Color/     | black | cod-3 |
 |  5 | Colored    | blue  | cod-1 |
 |  6 | Bottle     | black | cod-1 |
 |  7 | Bottles    | black | cod-2 |
 |  8 | Bottle/z   | black | cod-1 |
 |  9 | Bottleneck | blue  | cod-1 |
 +----+------------+-------+-------+
… 58 more words
Recent Questions - Stack Overflow

Do You Really Understand SQL's GROUP BY and HAVING clauses?

There are some things in SQL that we simply take for granted without thinking about them properly.

One of these things are the GROUP BY… 1,322 more words

Sql

Filter on the display method using context method

Example: InventSerial table

1. Add a display method for product number on the InventSerial table

display Name ItemDesc()
{
Name name;

name = InventTable::find(this.itemId).itemName();
return name;

346 more words
Ax 2012

Find duplicates in SQL

If you have a primary key setup for the table, there can be no rows that have duplicate ID (Primary key column). Therefore you can’t find duplicates based on that column. 56 more words

SQL

Simplifies SQL-style Computations – In-group Computation

During developing the database applications, we often need to perform computations on the grouped data in each group. For example, list the names of the students who have published papers in each of the past three years; make statistics of the employees who have taken part in all previous training; select the top three days when each client gets the highest scores in a golf game; and the like. 614 more words

EsProc

Simplifies SQL-style Computations – Relational Computation on Groups

During developing database applications, we are often faced with complicated SQL-style computations like relational computation on multilayered groups. As SQL requires summarizing during data grouping and it doesn’t support object-style relational access, it is difficult to deal with these computations. 1,101 more words

EsProc