Answers for "sql select one of two row based on value"

select 2 rows in sql

SELECT * FROM `table` WHERE id IN (1,2,3,...,n)

Posted by: Guest on August-12-2021

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
)

Posted by: Guest on June-17-2020

Code answers related to "sql select one of two row based on value"