how to write query

From: "Yoshitha" <gudivada_kmm@xxxxxxxxxxxxxx>
Date: Fri, 19 Aug 2005 13:04:04 +0530

I have a table with the fileds empid,empname,designation,branch.. etc I
have 5 types of designations CEO,BM,PL,Tester,and PRG and the two branches
those are Hyderabad and Visakhapatnam i need the query like
first CEO name next Hyderabad BM Name next Hyderabad PL name next Hyderabad
Testername next Hyderabad Prg Names next Visakhapatnam BM name next
visakhapatnam PL name next Visakhapatnam TesterNames and Visakhapatnam Prg
Names......

Please help...me

Regards,
Krishna Murthy.K

.

Follow-Ups:
- Re: how to write query
  - From: Hugo Kornelis

Prev by Date: Re: GROUP BY's on 3 tables in one SELECT?
Next by Date: Re: GROUP BY's on 3 tables in one SELECT?
Previous by thread: GROUP BY's on 3 tables in one SELECT?
Next by thread: Re: how to write query
Index(es):
- Date
- Thread