Home » Other » Training & Certification » A Querry
A Querry [message #290949] Wed, 02 January 2008 04:38 Go to next message
kecd_deepak
Messages: 52
Registered: December 2007
Member
We need to display employee names of department_id 20 on the top and then all the rest of the departments employees should be in ascending order.

[Edit MC: remove bold and size and move to homework]

[Updated on: Wed, 02 January 2008 05:11] by Moderator

Report message to a moderator

Re: A Querry [message #290950 is a reply to message #290949] Wed, 02 January 2008 04:57 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
What you have tried till now?
Try to put a decode and assign 0 or 1 and order by on that and then on the column, which you want in ascending order.

By
Vamsi

Report message to a moderator

Re: A Querry [message #290957 is a reply to message #290950] Wed, 02 January 2008 05:16 Go to previous messageGo to next message
kecd_deepak
Messages: 52
Registered: December 2007
Member
Thanks dear..................

Now it work correctly.

Report message to a moderator

Re: A Querry [message #291073 is a reply to message #290957] Wed, 02 January 2008 23:08 Go to previous messageGo to next message
prksingh
Messages: 3
Registered: April 2007
Location: Gurgaon
Junior Member
can u / anyone share query with me?

Thanks

Report message to a moderator

Re: A Querry [message #291077 is a reply to message #290949] Wed, 02 January 2008 23:23 Go to previous message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

It is just ORDER BY DECODE() ..

u / anyone can try it out .

Thumbs Up
Rajuvan.

Report message to a moderator

Previous Topic: Parameters Passing - Difference between Postional, Named, and Combination Methods
Next Topic: OCA PLSQL - OCA DBA
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 04:16:29 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.