Descending Order Snippets


14 May, 2012   

PL SQL Descending order in Oracle

02 January, 2012   

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

16 August, 2011   

Here are the code for checking running iOS 4++

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

22 March, 2012   

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

22 November, 2015   

To print out all possible subsets in lexicographic order

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.

An example of a simple double linked list using OOP techniques

CSS code example for different colors to visited/unvisited links

11 December, 2011   

CSS code example to use of text-decoration on links

21 April, 2012   

Retrieves a list of "on call" incidents for the most recent time period. Selects all Support Analysts.

07 August, 2014   

All hints except /*+ rule */ cause the CBO to be used. Therefore, it is good practise to analyze the underlying tables if hints are used (or the query is fully hinted.

12 July, 2012   

PHP MySQL code to select row randomly fast

Must have a field named Weight. The more Weight the more often the record is selected. Weight should be an integer between 1 and 10.

05 November, 2013   

Apache code example to limit access by IP address

05 October, 2016   

This code accumulates 100 units of part number 9999 from various storage bins

14 August, 2014   

Easy way to copy the contents of one table to another table.

29 July, 2013   

Selecting a Random Row from Table in MySQL

22 December, 2012   

How to select a random row in MySQL

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