News:

Free Image Hosting:
http://image-host.developers-heaven.net
Share your images free!!!

Main Menu
Menu

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.

Show posts Menu

Messages - Ovais

#1
Oracle / Get Maximum Records marked as asterisk
November 27, 2008, 01: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