Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
a7mad
Starting Member
1 Post |
 Posted - 2008-11-07 : 10:20:37
|
| Assume the table EMP with the following schema http://www.2shared.com/file/4235486/c4a2b73c/Untitled.html Figure 2 The EMP table a. Find the minimum salary of all employees in the EMP table. For example: MINIMUM 800 Answer: b. Find the minimum, maximum, and average salary of all employees in the EMP table. Answer: c. List the minimum and maximum salary for each job type in the EMP. Answer: d. Find how many managers are there without listing them. Answer: e. Find the difference between highest and lowest salaries. Answer: f. Check whether all employee numbers are indeed unique. Answer: g. Find all departments which have more than 3 employees. Answer: h. List lowest paid employee working for each manager. Exclude any groups where the minimum salary is less than 1000 and sort the output by salary. Answer: i have this problem so could any body fig out how it solve??? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-07 : 10:31:01
|
| These are the simplest questions you can get. Refer below link and start learning sql. Look forr grouping,aggregation and joins. Try out yourself and post you have any doubt. dont expect somebody to spoonfeed you on thishttp://www.w3schools.com/sql/default.asp |
 |
|
|
|
|
|
could any body help me plz