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 |
|
ramkumarodc
Starting Member
5 Posts |
 Posted - 2010-09-16 : 04:13:14
|
| 1.Display the manager number and the salary of the lowest paid employee for that manager. Exclude anyone whose manager is not known. Exclude any groups where the minimum salary is $6,000 or less. Sort the output in descending order of salary.2.Write a query to show the employee and the manager ids. The query should populate the manager id as the employee id itself if the employee doesn’t have a manager. In the result set, the Manager list should have the heading “Boss”.R~K |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2010-09-16 : 04:16:52
|
| What have you tried till now. Post sample data, expected output and sql that you have till now. |
 |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2010-09-16 : 04:26:47
|
| Just noticed, You have put this under the wrong forum. Might as well continue here http://www.sqlteam.com/forums/forum.asp?FORUM_ID=23 |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
please solve this sql query for me.