|
|
-
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...
|
-
My query gives your expected result...
|
-
This challenge is about finding second highest salary for each department...
|
-
My query gives your expected result...
|
-
rajeshmohanrangan Question Asked 2 Years ago through ASK
hi all
I had a doubt on below queries,can anyone explain it in detail how it works and also i need some more also like first one,
please give explanation too for wat u r giving example query..here
use pubs
select a.lastname from (select last...
|
ask
98
·
2% ·
538
|
|
-
rajeshmohanrangan Posted 2 Years ago through Ask
hi all
I had a doubt on below queries,can anyone explain it in detail how it works and also i need some more also like first one,
please give explanation too for wat u r giving example query..here
use pubs
select a.lastname from (select lastname f...
|
-
rajeshmohanrangan Liked 2 Years ago through Blogs
There is no direct way to multiply all the values of a column as we do summation using SUM(col). But it is possible with the following methods
create table test (i int, amount float)
insert into test(i,amount)
select
abs(cast(ca...
|
-
I just learned that while working in SSMS if you have a doubt you can ask in msdn forum using
the toolbar "Community > Ask a question" and the forum web page opens right within Books Online.......
|
-
rajeshmohanrangan Learned 2 Years ago through Just Learned
I just learned that while working in SSMS if you have a doubt you can ask in msdn forum using
the toolbar "Community > Ask a question" and the forum web page opens right within Books Online.......
|
-
I just learned that while working in SSMS if you have a doubt you can ask in msdn forum using
the toolbar "Community > Ask a question" and the forum web page opens right within Books Online.......
|