Hi Friends,

Please help me out with a optimized query for the following
as soon as possible with in today.Thanks in advance.

Employee Table

Eno 4 digits
Ename 20 digits

Salary Table

Eno 4 digits
Salary 8 digits

Query:

1. List the Name, Salary of the top 5 salaried person of the
company, in the Ascending order of the Salary.
2. Make the average of all odd no. of the salaries, and even no. of
the salaries and observe the difference. (in the sorted list of
salaries)







Subscribe: sql-general-subscribe (AT) yahoogroups (DOT) com
Unsubscribe: sql-general-unsubscribe (AT) yahoogroups (DOT) com
List owner: sql-general-owner (AT) yahoogroups (DOT) com
URL: http://groups.yahoo.com/group/sql-general
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/sql-general/

<*> To unsubscribe from this group, send an email to:
sql-general-unsubscribe (AT) yahoogroups (DOT) com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/