Click here to Skip to main content
Rate this: bad
good
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 27-Sep-12 19:37pm
Edited 28-Sep-12 20:31pm
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

select distinct id, name from tablename
 
this may help you...
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Hi
 
Can you give one sample table data with your expected answer
 
Thanks
Mohan
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 8,488
1 OriginalGriff 6,516
2 Peter Leow 3,647
3 Zoltán Zörgő 3,416
4 Richard MacCutchan 2,397


Advertise | Privacy | Mobile
Web03 | 2.8.150123.1 | Last Updated 29 Sep 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

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