• Home
  • About

Snippet IT

IT News, Programming, Internet and Blogging

  • Programming and Scripting
  • Tips and Tricks
  • Search Engine Optimization and Internet Marketing
  • Earning with Website and Blogging
  • Software and Hardware
  • New and Happening
  • Other
  • Sponsored Post
You are here: Home / Programming and Scripting / SQL: How To Select Data With Same Values On Columns

SQL: How To Select Data With Same Values On Columns

September 19, 2013 by Sze Hau Leave a Comment

Let say you have the following data in you database table t1 and you want to select the IDs for the row record that have the same value on COL1 and COL2.

ID   COL1   COL2   COL3
======================
1    100    200    300
2    200    300    400
3    100    200    500
4    300    300    300
5    200    300    400


And the expected result is ID = 1,2,3,5. The SQL to achive the result is:

select 
    left.ID
from
    t1 left inner join t1 right
on
    left.COL1 = right.COL1 and
    left.COL2 = right.COL2 and
    left.ID <> right.ID


You can also use “group by” then “count(*)” method but it is a bit more complicated and slow.

More from my site

  • Database: CHAR and VARCHAR – What are the differences?Database: CHAR and VARCHAR – What are the differences?
  • Java: How To Use SQL LIKE Clasue with PreparedStatement?Java: How To Use SQL LIKE Clasue with PreparedStatement?
  • Java: Loading Large Data into JTable or JListJava: Loading Large Data into JTable or JList
  • Java: How To Select Top N Objects From A ListJava: How To Select Top N Objects From A List
  • Wordpress: How To Add Table Into A PostWordPress: How To Add Table Into A Post
  • Wordpress: Catch A Spam Comment With StatcounterWordPress: Catch A Spam Comment With Statcounter

Filed Under: Programming and Scripting, Tips and Tricks Tagged With: SQL

About Sze Hau

Geek. Love programming. Coffee addicted. Married with two children. Working towards financial freedom.

Leave a Reply Cancel reply

Advertisement

  • Facebook
  • Google+
  • Instagram
  • Twitter

Email News Letter

Sign up to receive updates daily and to hear what's going on with us

Search Engine Optimization

Short URL: Top 5 Websites That Provide Free Short URL Service

December 10, 2009 By Sze Hau Leave a Comment

Google Chromium OS

November 23, 2009 By Sze Hau Leave a Comment

WordPress Plugin: Official StatCounter Plugin

November 13, 2009 By Sze Hau 1 Comment

Make Money With Website And Blogging

Wordpress

WordPress: How To Change Admin Username

September 23, 2015 By Sze Hau Leave a Comment

WordPress: Transfer Your Blogs To Another Hosting With Minimum Downtime

February 3, 2014 By Sze Hau Leave a Comment

Virtualmin: How To Install Virtualmin in CentOS

August 26, 2013 By Sze Hau Leave a Comment

Software and Hardware

iOS 5.1 Unable to Update

March 13, 2012 By Sze Hau Leave a Comment

Blog Network

  • All Gadget Latest Gadget Reviews and News
  • Blog Portal A place where bloggers gather
  • Personal Fincance Personal Finance – Personal Money Tips, Stock Investment, Small Business and Make Money Online
  • szehau's weblog Life, Internet, Software, Gadgets, Programming and Investments
  • Vista Talks Software News, Software Updates, Tips And Tricks

Snippet IT

This is the place where I want to share anything about information technology.

Search

Recent

  • MD5 and SHA1 Checksum Using Windows
  • MD5 and SHA1 Checksum Using Linux
  • Java: Unlimited Strength Jurisdiction Policy
  • WordPress: How To Change Admin Username
  • Linux: How To Compress And Decompress Folders And Files

Tags

Adsense advertisement advertising apache blog blogging tips C# EGPC error estimation format format Integer Gmail Google Google Adsense Google Chrome Google Search Engine Google search result how to HTTP internet marketing Java JavaScript Linux money password performance PHP programming search engine optimization secure security short URL SQL static constructor String tiny URL Tips and Tricks twitter video Windows Vista Wordpress wordpress plugin wordpress theme Youtube

Copyright © 2021 · Magazine Pro Theme on Genesis Framework · WordPress · Log in