SQL - TechRepublic
General discussion
October 13, 2003 at 02:38 PM
umer

SQL

by umer . Updated 22 years, 8 months ago

Hi
Can anyone help in giving query code for these problems:

1- List the surname of any employee who does not have an e in their surname.

2- Find the number of jobs employee 22 has had or has currently.

3- List all of the empnos of employees and their position in 1984.

4- What was the average salary in 1988? Look at employees who where employed on the last day of 1988.

5- Count the number of employee who has a forename starting with M or A.

6-List the employee numbers and telephone numbers ordered by descenending

This discussion is locked

All Comments