News:

To still receiving newsletters from us please subscribe to our Newsletters:
http://tech.groups.yahoo.com/group/developers-Heaven/

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

Topics - 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