Комментарии:
Sir, how can we update the second-highest salary department-wise by 1000? Please answer 🙏 I am trying to solve this query for the week.
ОтветитьThank you Sir 🙏
ОтветитьHello Sir,
Can you please make a video on this?
We have Team1 Team2 Winner columns in a table called matches:
Team1 Team2 Winner
Ind Aus Ind
Aus NZ NZ
Nz SA SA
SA ENG ENG
ENG PAK PAK
1) How many matches are played By IND
2) How many matches were played
3) what are the teams where at least matches were played.
4) what are the teams where at least matches were won.
select * from(
select salary,deptno,dense_rank() over(partition by deptno order by salary desc)rnk from emp)
where rnk=2;
Sir if source system is in CSV and Excel file or in different db how can I validate the data iscorrect or not? Before migration and after migration?
ОтветитьHow to calculate percentage of student marks ?
ОтветитьNicely explain.
This can be achieved by dense_rank also
First view
Ответить