My favorites
▼
|
Sign in
robcthegeek
Codepit for robcthegeek
Project Home
Issues
Source
Checkout
Browse
Changes
Source path:
svn
/
trunk
/
sqlfordevelopers
/
ThirdHighestSalary.sql
r30
1
2
3
4
SELECT TOP 1 * FROM
(SELECT TOP 3 ID, FirstName, LastName, Salary, Role
FROM Staff ORDER BY Salary DESC) sort
ORDER BY Salary;
Show details
Hide details
Change log
r15
by robc.the.geek on May 5, 2009
Diff
Tech Day #4 (SQL for Developers) Content
Go to:
/trunk/sqlfordevelopers
/trunk/sqlfordevelopers/Data.mdf
...nk/sqlfordevelopers/Data_log.ldf
...developers/FormattingCSOutput.cs
...nk/sqlfordevelopers/NthRecord.cs
...developers/ProceduralThinking.cs
...evelopers/ProceduralThinking.sql
...velopers/Restore Staff Table.sql
...rdevelopers/SetBasedThinking.sql
...rs/SetBasedThinkingRevisited.sql
...evelopers/ThirdHighestSalary.sql
...opers/ThirdHighestSalary2005.sql
Project members,
sign in
to write a code review
Older revisions
All revisions of this file
File info
Size: 129 bytes, 4 lines
View raw file
Powered by
Google Project Hosting