Answers for "select multiple rows with same column value"

select rows with same value in a column

select * from table where email in (
    select email from table
    group by email having count(*) > 1
)

Posted by: Guest on June-10-2021

select records based on multiple columns

new_df = old_df[((old_df['C1'] > 0) & (old_df['C1'] < 20)) & ((old_df['C2'] > 0) & (old_df['C2'] < 20)) & ((old_df['C3'] > 0) & (old_df['C3'] < 20))]

Posted by: Guest on June-02-2021

Code answers related to "select multiple rows with same column value"