Click here to Skip to main content
14,573,754 members
Rate this:
Please Sign up or sign in to vote.
I have One Table Like This

Id Bill_No Item_Name Article_no Category Price Supplier_name Date
1 as001 Jeans 600 Levice 1000 Manu 24/12/2011
2. as001 Jeans 600 Levice 1000 Manu 24/12/2011
3 as001 Shirt 600 Levice 400 Manu 24/12/2011
4 as002 Jeans 600 Levice 1000 Rakesh 25/12/2011
5 as002 Jeans 400 Lux 1200 Rakesh 25/12/2011

I want To Retrieve Table Like This :

Bill_no Supplier_Name Date
as001 Manu 24/12/2011
as002 Rakesh 25/12/2011

How To Do It Help Me
Posted
Updated 24-May-19 9:54am
v2

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 2

select distinct id, name from tablename


this may help you...
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100