TSQL Beginners Challenges - TSQL Beginners Challenge 1 - Find the second highest salary for each department

Getting Started with Adobe After Effects - Part 6: Motion Blur

Liked


	TSQL Beginners Challenges

Upload Image

Close it

Select File

The challenge is to find the employees with the second highest salary in each department. However, it is a little more complicated because if two employees have the same salary, you need to list both of them.


	Like

Invite Friends

TSQL Beginners Challenge 1 - Find the second highest salary for each department

Home · Challenge Details · Comments · Solutions · Fans (186) · Preferences

Submit a Solution

0
Liked

1
Comments

Beginners Challenge 1

This solution starts with a table variable, which a CTE then uses The final query selects from the CTE....

nocat50 Posted on Jan 2 2013 12:00AM
Profile

0
Liked

solution to TSQL Beginners Challenge 1

using dense_Rank()...

chandni Posted on Dec 28 2012 12:00AM
Profile

0
Liked

2
Comments

solution to TSQL Beginners Challenge 1

...

chandni Posted on Dec 28 2012 12:00AM
Profile

0
Liked

1
Comments

TSQL Beginners Challenge 1 - Find the second highest salary for each department

this is my first submit I hope it's ok! EDITED: I was seeing another solutions and I saw that they used rank(), partition() and things like that , that I've never saw before :P, hope someone will give some links to learn to make queries that way, and I ...