Select Distinct coulmn_name(1), coulmn_name(2), coulmn_name(3), coulmn_name(4)
from table_name
Group by coulmn_name(1), coulmn_name(2), coulmn_name(3), coulmn_name(4)
Example
Select Distinct listing_Id, buyer_org_id, buyer_org_name, seller_city_repo from category.food_fmcg_sales
Group by listing_Id, buyer_org_id, buyer_org_name, seller_city_repo
Output
No comments:
Post a Comment