SQL-Distinct


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