Sql Order Snippets


02 January, 2012   

The ORDER BY keyword is used to sort the result set by a specified column.

In order for this to work, you will need to copy mysqldump.exe and mysql.exe from the MySQL bin Program Files folder into the same directory as your executing PHP script. If you know the direct path to these for your server, you can use those instead.

16 August, 2011   

Here are the code for checking running iOS 4++

14 May, 2012   

PL SQL Descending order in Oracle

21 January, 2012   

PL/SQL Block that uses implicit cursor attributes as below example code.

This sql statement enables to detect duplicates entries over a key and creates a seq column which says which one is the sequence of the duplicates. This way you can take only the seq = 1 and still be able to identify all duplicates

This function builds an HTML select list from from data retrieved from a mySQL table.

01 December, 2011   

The following code block shows how to run DML statements in PL/SQL. Basically they look similar to the SQL. Note that the SELECT statement retrieves the single-row value and store into a variable using INTO clause.

The four link states should always be listed in that order, like so:

09 May, 2011   

This is a general code to use when selecting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. Note: This code requires you to connect to the MySQL database to work. Also, all field and table names need to be set up to match. This MYSQL Code using in PHP

This code will break a string of words up along the spaces and do a mySQL search for each of the words in the string.

This code will break a string of words up along the spaces and do a mySQL search for each of the words in the string.

Exam code to backup MySQL Database to SQL File

18 January, 2012   

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

22 March, 2012   

An example CSS code for Link Pseudo-Classes (In Order)

PHP & Mysql based code to Print table with client-side sorting function.

22 November, 2015   

To print out all possible subsets in lexicographic order

PL/SQL functions returns a scalar value and PL/SQL procedures return nothing. Both can take zero or more number of parameters as input or output. The special feature about PL/SQL is that a procedure/function argument can be of input (indicating the argument is read-only), output (indicating the argument is write-only) or both (both readable and...

08 September, 2012   

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

26 November, 2015   

Show the currently active processes.