I have a table my_table
I want a query which selects 5 rows where col='A' and 5 rows where col='B'
so i should have a total of 10 rows.
but the following query does not work as intended.
where col= 'A'
where col= 'B'