Group By Snippets


18 January, 2012   

SQL GROUP BY Clause returns group of rows. An example code for SQL GROUP BY clause

08 September, 2012   

SQL query to know total number of employee on each department.

MySQL code to find all duplicates in a database column(s)n.

18 January, 2012   

You can combine with SQL JOIN clause to show department name with count.

31 December, 2011   

MySQL's MAX aggregate function will find the largest value in a group. here shown an example

24 August, 2013   

MySQL code to find duplicate records in table

Oracle PL/SQL example for avoiding overlapping months and years

04 January, 2012   

SQL example Code for SELECT statement with HAVING clause

13 March, 2012   

PL/SQL code example Using the HAVING Clause

PL/SQL code example for using the MAX function with having clause

09 April, 2011   

On form, insert a Page Break after the first group of fields. This creates two "pages" in the form, which can be toggled using a command button on each.

24 June, 2015   

Create a table with the results from a SELECT statement.

An example of finding duplicate values in a table column

09 September, 2014   

Simple Javascript snippet that lets you toggle a group of checkboxes on or off at the same time. This is the format for your HTML form.

18 December, 2014   

Example code for locking table. when a user modifies data through a transaction, that data is locked by that transaction until the transaction is committed or rolled back.

21 December, 2013   

Great page for testing the style guide for a website.

11 July, 2013   

Help manage mysql database common task

C++ Example code to convert a real number to the string

Converts the given floating-point value to a zero-terminated string. The supplied buffer should be large enough to accommodate the converted value. The value includes a decimal point and possiblesign and exponent information, plus a terminating null character, which is appended automatically. Returns: a pointer to zero-terminated...

11 April, 2011   

Specifications of the TOPIC database format, a standardized structure for plain text databases that's easy to read and edit in most text editors, and easy to programmatically parse as well.