Hi every SQL-users !

Assuming you guys have access (!) to the HR client data table (Employee) which contains all employee's important data like client_id, client_name,... and salary.

You must sometimes have been temptated to know who are the TOP 10 in salary rank !

How do you write the SQL in following environments:
a) Oracle
b) SQL Server
c) Any SQL database

Some photos were taken in Grachen,Switzland in August 2010

We begin this New Year with dampened enthusiasm and dented optimism. Our happiness is diluted and our peace is threatened by the financial illness that has infected our families, organizations and nations. Everyone is desperate to find a remedy that will cure their financial illness and help them recover their financial health.

No any trick, only pure logic
So good luck and not giving up!

1. There are 5 houses with different color
2. There are different national people living in these houses.
3. Everybody prefers a kind drink, cigarette mark and pet.
4. Different people have different drink, cigarette, pet

Question: Who keeps the fish?

Statements:

One day, the father explained to his son the math formula 7 – 12 + 5 = 0 :

Imagine:

There were 7 people traveling on a bus. At the bus stop, 12 people got off from the bus. Now exact 5 people should get on the bus so that NOBODY will be there!

Here is description of SQL from Wikipedia ( http://en.wikipedia.org/wiki/SQL ):