Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Ovais

Pages: [1]
1
Oracle / Get Maximum Records marked as asterisk
« 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

Pages: [1]