 |
 |
 |
 |
 |
 |
 |
|
|||||||
| Register | FAQ | Members List | Calendar | Advertise With Us | Mark Forums Read | |||
|
|
||||||||
|
Welcome to United Bimmer Community - BMW Forum . You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| E36 General discussion and technical help for (E36) 1992-1999 3 series cars. 318, 323, 325, 328. |
 |
|
|
Thread Tools |
04-21-2009, 09:17 AM
|
#1 |
|
????????
1)SELECT LAST_NAME, date_format(HIRE_DATE, '%e-%b-%y') as "HIRE_DATE" FROM EMPLOYEES WHERE LAST_NAME <> 'Zlotkey' and HIRE_DATE IN (SELECT HIRE_DATE FROM EMPLOYEES WHERE DEPARTMENT_ID=80); 2)SELECT EMPLOYEE_ID, LAST_NAME, SALARY FROM EMPLOYEES GROUP BY EMPLOYEE_ID having salary>(select avg(salary) from employees) ORDER BY SALARY ASC; |
|
|
| Sponsored Links | |
|
|
|
|
«
Previous Thread
|
Next Thread
»
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
|
|
