Comments by Giri Bkm (Top 5 by date)

Select
'Batting',
Max(IPL__Name) As IPL__Name,Max(HighestRunsAndWicketsInIPL) As HighestRunsAndWicketsInIPL,Max(Test__Name) As Test__Name,Max(HighestRunsAndWicketsInTest) As HighestRunsAndWicketsInTest,Max(T20I__Name) As T20I__Name,Max(HighestRunsAndWicketsInT20I) As HighestRunsAndWicketsInT20I,Max(ODI__Name) As ODI__Name,Max(HighestRunsAndWicketsInODI) As HighestRunsAndWicketsInODI
From (
Select
MatchType + '_' + '_Name' As Type1,
FirstName + ' ' + MiddleName + ' ' + LastName As Runs1,
'HighestRunsAndWicketsIn' + MatchType As Type,
RunsScored As Runs
From (
Select
FirstName,
MiddleName,
LastName,
MatchType,
RunsScored
From (
Select
s.Id,
a.FirstName,
a.MiddleName,
a.LastName,
s.MatchType,
s.RunsScored,
Row_Number() Over(Partition By MatchType Order By RunsScored Desc) rn
From
PlayersCareerBatting s Join PlayersBioDataNew a
On s.Id=a.Id
) x
Where rn=1
) x2
) x3
Pivot
(
Max(Runs1) For Type1 In ([IPL__Name],[Test__Name],[T20I__Name],[ODI__Name])
) x4
Pivot
(
Max(Runs) For Type In ([HighestRunsAndWicketsInIPL],[HighestRunsAndWicketsInTest],[HighestRunsAndWicketsInT20I],[HighestRunsAndWicketsInODI])
) x5

Union

Select
'Bowling',
Max(IPL__Name) As IPL__Name,Max(HighestRunsAndWicketsInIPL) As HighestRunsAndWicketsInIPL,Max(Test__Name) As Test__Name,Max(HighestRunsAndWicketsInTest) As HighestRunsAndWicketsInTest,Max(T20I__Name) As T20I__Name,Max(HighestRunsAndWicketsInT20I) As HighestRunsAndWicketsInT20I,Max(ODI__Name) As ODI__Name,Max(HighestRunsAndWicketsInODI) As HighestRunsAndWicketsInODI
From (
Select
MatchType + '_' + '_Name' As Type1,
FirstName + ' ' + MiddleName + ' ' + LastName As Wickets1,
'HighestRunsAndWicketsIn' + MatchType As Type,
Wickets As Wickets
From (
Select
FirstName,
MiddleName,
LastName,
MatchType,
Wickets
From (
Select
s.Id,
a.FirstName,
a.MiddleName,
a.LastName,
s.MatchType,
s.Wickets,
Row_Number() Over(Partition By MatchType Order By Wickets Desc) rn
From
PlayersBowlingCareer s Join PlayersBioDataNew a
On s.Id=a.Id
) x6
Where rn=1
) x7
) x8
Pivot
(
Max(Wickets1) For Type1 In ([IPL__Name],[Test__Name],[T20I__Name],[ODI__Name])
) x9
Pivot
(
Max(Wickets) For Type In ([HighestRunsAndWicketsInIPL],[HighestRunsAndWicketsInTest],[HighestRunsAndWicketsInT20I],[HighestRunsAndWicketsInODI])
) x10

But i want that sub-queries, and also i dont know how to reduce the sub-queries

I'm very sorry. I don't want reduce. I want to increase the speed of that query. Pls give the solution for how can I increase the speed of that query. Thanks in advance

Oops! Sorry, this query is running slow right now. I want to run this query even more faster
Thanks in advance