|
Home > Archive > MS SQL Server ODBC > August 2005 > how to write query
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
how to write query
|
|
| Yoshitha 2005-08-19, 3:23 am |
| I have a table with the fileds empid,empname,design
ation,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
| |
| Warren Read 2005-08-31, 8:23 pm |
| Wow. Complicated.
Perhaps you could split your query into smaller queries?
To get this to do what you want try searching on-line for 'SELECT' and
'GROUP BY'. You might find some examples that will guide you toward what
you want.
Sorry I wasn't much help. Good luck!
--------------------
| From: "Yoshitha" < gudivada_kmm@rediffm
ail.com>
| Subject: how to write query
| Date: Fri, 19 Aug 2005 13:04:18 +0530
| Lines: 18
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| Message-ID: <OGJgu#IpFHA.3828@TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: 59.145.128.68
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2598
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| I have a table with the fileds empid,empname,design
ation,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
|
|
|
|
|
|
|
|