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

[@zaravind4293]

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

[@yaswanthkumarreddyvalluru9303]

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-ll1yq]

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

[@prashantsamant2730]

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 ;

[@vikasrajput226]

for 1 question you took aprox 15 mins.

[@CloudyML]

Hi Vikas, this is for teaching purpose and we have shown 3 ways to solve this problem. That's why it took time.