View previous topic :: View next topic
|
Author |
Message |
lanand_hps
New User
Joined: 05 Dec 2007 Posts: 82 Location: chennai
|
|
|
|
Hi,
I've two columns employee name and type
Emp Type
George AB
George SJ
George SH
George ZA
George 12
George 13
Anand SJ
Anand SH
I'm using a cursor and grouping it by employee name.
Is it possible to take SH records first and then the other records?
The order of fetch i want is
Emp Type
George SH
George AB
George SJ
George ZA
George 12
George 13
Anand SH
Anand SJ
I'm sure there must be a way. Pl give your opinion. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
You already asked the same question even if with different data and column names,
it should not be difficult to apply to this case the same technique that was explained to You in the other thread |
|
Back to top |
|
|
lanand_hps
New User
Joined: 05 Dec 2007 Posts: 82 Location: chennai
|
|
|
|
I didn't get correct answer for the other thread.
I'm presenting the question in a different manner so that ppl would appreciate the query better. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
did You test it ?
what makes You think that You will get a different/better reply from reposting ? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
Back to top |
|
|
lanand_hps
New User
Joined: 05 Dec 2007 Posts: 82 Location: chennai
|
|
|
|
I tested it. It didnt work.
Thanks for the link anyways. It was useful.
But what I was wanted was different friend... |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
If You posted the db2 release level |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
I tested it. It didnt work. |
So, how did it not work?
For you to get "better" results from the forum, you have to provide proper feedback. If the "other" reply did not meet your request, why did you not reply back to that topic with this info? When someone posts a reply to a "how to" question (and you won't take the time to reply that you did not understand what they posted or that it did not work), people here believe your request was satisfactorily answered.
Starting the same question as a new topic just introduces clutter for us and does you no good either. |
|
Back to top |
|
|
|