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: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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
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.
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
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.
Previous Topic: Parameters Passing - Difference between Postional, Named, and Combination Methods
Next Topic: OCA PLSQL - OCA DBA
Goto Forum:
  


Current Time: Fri Dec 02 18:52:05 CST 2016

Total time taken to generate the page: 0.44586 seconds