Zuber Kazi

Zuber Kazi

  • NA
  • 36
  • 34.3k

query for distinct records

Aug 16 2012 6:09 AM
Hello All,
I have a table named store_master in which store_name, manager,supervisor are the fields.
User have entered values as follows

store_namemanagersupervisor
mumbaiaz
mumbaibz
mumbaicy
thanedx
thaneex
navi mumbaifw

Now I want distinct store_name followed by there last manager and supervisor.
Please help.
Regards,
Zuber Kazi  

Answers (5)