Check Duplicates In Column Snippets


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

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

Returns the text between the specified delimiters in MySQL.

Returns the text between the specified delimiters in MySQL.

Create in dbgrid one column and insert the caption "RecNo" or other in title property. In dbgrid onDrawColumnCell event insert the following code:

13 October, 2015   

This function removes all duplicated lines of the given text file.

Toggle a column bit regardless of state. Useful to change state without doing a query first to detect the state of the bit.

12 July, 2012   

PHP MySQL code to select row randomly fast

23 October, 2012   

MySQL code example for sorting data in a GRID

27 August, 2011   

The <frame> tag defines one particular window (frame) within a frameset. In the example below we have a frameset with two columns. The first column is set to 25% of the width of the browser window. The second column is set to 75% of the width of the browser window. The document "frame_a.htm" is put into the first column, and...

Example for adding filter column to FilterControl, Devexpress controls

12 January, 2012   

Here shown a php code example how to associative Array by Column Name

Get number of paragraphs in column 2 and display that number in an alert box. Including the one in the red box.

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.

PHP code to add sortable column to WordPress in admin area .

Example: There is a table, 'user', with a column, 'clear', containing values such as: `clear \'animal\' \'pass'\ ` and we would like to retrieve 'animal' and 'pass' ( without the pre & post \' )

Example code to update or convert the field to UPPERCASE.

20 August, 2014   

Javascript function to check or uncheck all the checkboxes in a form.

11 October, 2012   

Python code example for Grid made by Label and Entry

An example of finding duplicate values in a table column