SQL. We have a table below : Team ------ India England Srilanka Can you write a SQL code, by which we can generate all possible combinations between the above input teams? We have the below dataset : Employee_salary Sanpshotdate | Employee | Doj | Current Salary -------------------------------------------------------- 01-Jan-2022 | 1 | 01-Jan-2021 | 1000 01-Jan-2023 | 1 | 01-Jan-2021 | 2000 01-Jan-2024 | 1 | 01-Jan-2021 | 2300 01-Jan-2025 | 1 | 01-Jan-2021 | 3000 a) Print for each employee what was current and immediate previous salary b) Identify the employees based on the highest increase of salary from the first salary, who have joined more than 2 years ago c) Identify the employees where salary increase between the last two years are more compared to the average salary increase in the last two years
Anonymous
Can you write a SQL code, by which we can generate all possible combinations between the above input teams? Answer- SELECT T1.Team, T2.Team from T T1, T T2 WHERE T1.Team< T2.Team --T is table name
Check out your Company Bowl for anonymous work chats.