Resources
Answers
Examples
Sign in
Get Started
What do you want to save?
Add Code snippet
New code examples
SQL
2022-01-23 23:05:24
how to find symmetric pairs in sql
SELECT f1.X, f1.Y FROM Functions AS f1 WHERE f1.X = f1.Y GROUP BY f1.X, f1.Y HAVING COUNT(*) > 1
Add solution
SQL
2021-11-22 02:11:11
query postgres delete duplicates
DELETE FROM dups a USING ( SELECT MIN(ctid) as ctid, key FROM dups GROUP BY key HAVING COUNT(*) > 1 ) b WHERE a.key = b.key AND a.ctid <> b.ctid
Add solution
TypeScript
2021-11-05 10:20:05
how to get duplicate elements in sql
SELECT username, email, COUNT(*) FROM users GROUP BY username, email HAVING COUNT(*) > 1
Add solution
SQL
2021-10-23 02:02:13
select count postgres double row count > 1
SELECT firstname, lastname, count(*) FROM people GROUP BY firstname, lastname HAVING count(*) > 1;
Add solution
SQL
2021-10-09 17:55:09
sql select rows with different values in one column
SELECT * FROM YourTable WHERE ARIDNR IN ( SELECT ARIDNR FROM YourTable GROUP BY ARIDNR HAVING COUNT(*) > 1 )
Add solution
SQL
2021-10-04 04:20:05
get duplicate records in sql
SELECT username, email, COUNT(*) FROM users GROUP BY username, email HAVING COUNT(*) > 1
Add solution
SQL
2021-10-03 18:47:03
sql distinct vs unique
SELECT [EmailAddress], [CustomerName] FROM [Customers] WHERE [EmailAddress] IN (SELECT [EmailAddress] FROM [Customers] GROUP BY [EmailAddress] HAVING COUNT(*) > 1)
Add solution
SQL
2021-10-01 11:35:04
sql count duplicate rows
SELECT username, email, COUNT(*) FROM users GROUP BY username, email HAVING COUNT(*) > 1
Add solution
SQL
2021-09-30 08:33:03
how to get non distinct values in sql
SELECT [EmailAddress], [CustomerName] FROM [Customers] WHERE [EmailAddress] IN (SELECT [EmailAddress] FROM [Customers] GROUP BY [EmailAddress] HAVING COUNT(*) > 1)
Add solution
SQL
2021-09-22 11:00:07
sql insert multiple rows
SELECT _column, COUNT(*) FROM _table GROUP BY _column HAVING COUNT(*) > 1
Add solution
‹
1
2
›
Best helpers
daily
weekly
monthly
for 3 months
Frankie Robertson
+5
Bin Nguyễn
+5
Buttercup
+5
David Scarbrough
+5
Vidhi Patel
+5
IsaacsLaughing
+5
Gruppetto
+5
Kateřina Van Wagenen
+5
Mai Rose
+5
Inoutguttiwutts
+5
Shaghayegh.af
+5
Fishbean
+5
James Song
+5
Eric Vought
+5
show more
This website uses cookies to make IQCode work for you. By using this site, you agree to our
cookie policy
Welcome Back!
Sign up to unlock all of IQCode features:
Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings
Sign in
E-mail
Password
Recover lost password
Log in
Or log in with
Not registered?
Sign up takes less than a minute
Create a Free Account
Sign up to unlock all of IQCode features:
Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings
Sign up
Email
Password
Sign up for free
Or sign up with
By signing up, you agree to the
Terms and Conditions
and
Privacy Policy
. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.