Make records rise to the top - sorting
I'm trying to get a sub group of records to display first before the rest of the group.
For example, I make a selection of real estate properties and the result is 22 records. The records are ordered by 'price'. Two of these records, which belong to a partcular agent, I want to have show up above the others. There is a column in the real estate property table that holds the agent's id so I know what two records belong to this agent.
Is there a way to do this using one query?
Subject
Written By
Posted
Make records rise to the top - sorting
August 15, 2004 02:02PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.