Select rows with same id but different value in another column

by

Try this please. I checked it and it’s working:

SELECT *
FROM Table
WHERE ARIDNR IN (
    SELECT ARIDNR
    FROM Table
    GROUP BY ARIDNR
    HAVING COUNT(distinct LIEFNR) > 1
)

More Related Contents:

  1. SQL Selecting from three tables
  2. How to cast the DateTime to Time
  3. Inner join vs Where
  4. Computed / calculated / virtual / derived columns in PostgreSQL
  5. Generate a resultset of incrementing dates in TSQL
  6. Find a string by searching all tables in SQL Server
  7. Xcode 4 and Core Data: How to enable SQL Debugging
  8. Database Design for Revisions?
  9. How to use parameters “@” in an SQL command in VB
  10. JPQL IN clause: Java-Arrays (or Lists, Sets…)?
  11. Finding similar strings with PostgreSQL quickly
  12. Why use a JOIN clause versus a WHERE condition?
  13. Window Functions or Common Table Expressions: count previous rows within range
  14. sql varchar(max) vs varchar(fix)
  15. Optimize groupwise maximum query
  16. Huge performance difference when using GROUP BY vs DISTINCT
  17. Use email address as primary key?
  18. Convert Date format into DD/MMM/YYYY format in SQL Server
  19. Get execution time of PostgreSQL query
  20. SQL Script to alter ALL Foreign Keys to add ON DELETE CASCADE
  21. How to combine results of two queries into a single dataset
  22. SQL Server 2005 and temporary table scope
  23. psql invalid command \N while restore sql
  24. How to select a record and update it, with a single queryset in Django?
  25. Select SQL Server database size
  26. SQL INSERT INTO from multiple tables
  27. How to Execute SQL Query without Displaying results
  28. Retrieve Oracle last inserted IDENTITY
  29. RegEx to Detect SQL Injection
  30. PostgreSQL – dynamic value as table name [duplicate]

Leave a Comment