Sign in
|
Join
Home
Blogs
Ask
Just Learned
Interview Questions
Puzzles
Tutorials
Quiz
Modules
Getting Started with Adobe After Effects - Part 6:
Motion Blur
First Time? You can support us by signing up. It takes only 5 seconds. Click
here
to sign up. If you already have an account, click here to
login
.
Friends
Request Friendship
rajeshmohanrangan
Upload Image
My Home
My Discussions
My Friends
My Points
My Sections
My Activities
ORACLE - PLSQL Challenges
4
Ask
2
Blogs
1
Just Learned
6
rajeshmohanrangan
960 ·
0% ·
27
rajeshmohanrangan - ORACLE - PLSQL Challenges
Home (4)
·
·
Solutions (3)
·
Points (8)
Rank Function-In Sqlserver
rajeshmohanrangan
Commented 2 Years ago through
ORACLE - PLSQL Challenges
| 1 Point
WITH RankedData AS ( SELECT SD.EmployeeID, SD.EmployeeName, SD.Department, SD.Salary, Dense_Rank() OVER (PARTITION BY SD.Department ORDER BY SD.Salary DESC) AS SalaryRank FROM PLC2_EMPLOYEES SD ) select EmployeeI...
Rank Function-In Sqlserver
rajeshmohanrangan
Liked 2 Years ago through
ORACLE - PLSQL Challenges
| 1 Point
My query gives your expected result...
PLSQL Challenge 2 - Find the second highest salary for each department
rajeshmohanrangan
Liked 2 Years ago through
ORACLE - PLSQL Challenges
| 1 Point
This challenge is about finding second highest salary for each department...
Rami Reddy
2 ·
41% ·
12972
Rank Function-In Sqlserver
rajeshmohanrangan
Submitted 2 Years ago through
ORACLE - PLSQL Challenges
| 5 Points
My query gives your expected result...
Managed Windows Shared Hosting
by OrcsWeb
Copyright © Rivera Informatic Private Ltd.