Sql

Search

sql select if two columns are equal

SELECT ta.C1
      ,ta.C2
      ,ta.C3
      ,ta.C4
FROM [TableA] ta
WHERE (SELECT COUNT(*)
       FROM [TableA] ta2
       WHERE ta.C2=ta2.C2
       AND ta.C3=ta2.C3
       AND ta.C4=ta2.C4)>1

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql update multiple columns
Sql :: sql pass table name as variable
Sql :: mysql_num_fields in mysqli
Sql :: mysqldump database
Sql :: show table mysql
Sql :: insert array into mysql column
Sql :: sql sequence
Sql :: ms sql mac
Sql :: mysql where length greater than
Sql :: sql use not in
Sql :: postgresql in array
Sql :: install mysql for fedora 34
Sql :: import mysql dump database command line linux
Sql :: add clumn to table postgres
Sql :: sql to array of objects
Sql :: pl sql create table from another table
Sql :: uncheck constraints and delete from table
Sql :: mysql changer nom table
Sql :: mysql disable triggers
Sql :: insert query mysql workbench
Sql :: postgresql escape single quote
Sql :: How to search for a String in all Columns in all tables in SQL Server Database
Sql :: case insensitive sql
Sql :: sql distinct clause
Sql :: mysql:5.6 syntax create table
Sql :: delete vs truncate sql server
Sql :: power query datetime to date
Sql :: replace content value from old to new sql
Sql :: sql distinct vs unique
Sql :: select indexes postgres

Search

SQL

sql select if two columns are equal

ADD CONTENT