Group By Clause Snippets

18 January, 2012   

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

18 January, 2012   

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

04 January, 2012   

SQL example Code for SELECT statement with HAVING clause

08 September, 2012   

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

13 March, 2012   

PL/SQL code example Using the HAVING Clause

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

20 February, 2012   

SQL select query to show records with specify date in where clause

07 September, 2014   

The "WITH CHECK OPTION" is used to indicate that Oracle will prevent any changes to the table or view that would produce rows that are not included in the subquery. When used in the subquery of a DML statement, you can specify this clause in a subquery in the FROM clause but not in subquery in the WHERE clause.

20 February, 2012   

SQL select query with between date to show records in where clause

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

02 November, 2014   

The RETURNING clause was implemented as part of the Oracle 10g release and is used to return information about the effected rows after issuing Data Manipulation Language (DML) statements.

If we wanted to select only certain entries of our table, then we would use the WHERE clause .

31 December, 2011   

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

29 March, 2015   

When creating an index, the default method Oracle uses to sort the index is in ascending order (SORT). However, if the rows are already stored in the database in ascending order you can use the NOSORT clause to skip the sorting process. If neither SORT or NOSORT is provided, Oracle will use SORT as the clause.

28 June, 2014   

Starting in Oracle 9i, you can use the case statement within an SQL statement. It has the functionality of an IF-THEN-ELSE statement.

19 February, 2012   

Throwtest an application that demonstrates how to define, throw, and handle exceptions. This application doesn't do anything other than print out some text, but if you might want to study it and play around with it to learn more about how exceptions work in Java. See the usage instructions in the source code.

24 August, 2013   

MySQL code to find duplicate records in table

Oracle PL/SQL example for avoiding overlapping months and years

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.