Author Topic: Get Maximum Records marked as asterisk  (Read 7365 times)

Offline Ovais

  • Newbie
  • *
  • Posts: 1
    • View Profile
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