SQL Interview Question Asked in INFOSYS | Mastering SQL 🔥🔥🔥 | Data Science Interview Questions

In this video we are going to discuss SQL Interview question asked in Infosys using 3 approaches. Do hit like and subscribe and share with others if you enjoyed the content.

Check our Data Science & Analytics Courses on our website. We provide hands-on practical learning experience to our learners with 1-1 Live Doubt Clearance Support over Skype Chat everyday. Also you will get projects and case studies that you can add in your resume.

➡️1. Data Science and Analytics Mega Combo Course (Offer Price - Rs.6999/-)

➡️2. Data Science Combo Course (Offer Price - Rs.3999/-)

➡️3. Data Analytics/ Business Analytics Combo Course (Offer Price - Rs.3990/-)

➡️4. For More Courses, check our Website Homepage.

Our Social Media Channels

Stay Safe and Keep Learning
- Team CloudyML

#sql #sqlinterview #sqlinterviewquestionsandanswers

[zaravind]

select Id from
(select weather.*, case when temp>lag(temp, 1) over(order by id)
then 1 else 0 end as newcol from weather)
where newcolu=1;

Above query also works fine

[yaswanthkumarreddyvalluru]

select w.id
from(select id, [Date], temperature,
lag(temperature) over(order by [Date]) as prevtemp
from Weather) w
where w.temperature>w.prevtemp

CAN BE SOLVED USING LAG WINDOW FUNCTION

[vijay.s-llyq]

with cte as
(select *, lag(temp, 1, temp) over (order by id) as compare_lag from weather)

select id from cte
where temp > compare_lag

[prashantsamant]

Select id from (select * from weather
case
when temp > lag(temp, 1) over(order by id) then 1
else 0
end) as res
where res = 1 ;

[vikasrajput]

for 1 question you took aprox 15 mins.