Developers Heaven Forum

DataBase => Oracle => Topic started by: Ovais on November 27, 2008, 08:26:08 AM

Title: Get Maximum Records marked as asterisk
Post by: Ovais on November 27, 2008, 08:26:08 AM

Hi...

I want to get the query to display all records from a table in such a way that 3 maximum records should display first with marked as asterisk..
Example:

ID    Name       Salary
5     John        5,000*
3     Peter       4,000*
1     Brown      3,000*
2     Boje        2,000
4     David      1,000

Plz answer the query...

Thanks.

Ovais