SQL #57–A one-liner query with PARTITION BY

What can be done in SAS must be possible in SQL

A friend of mine is a data professional in marketing data analysis with expertise in SAS and pretty good working knowledge of SQL. 879 more words

SQL Challenge

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


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