SQL Interview Question | 04 | #dataengineering | #dataanalyst | #powerbi | #sql #dataengineer

If you like this video please
like share , subscribe and comment down below..
if you have any suggestion or doubt this video.

Scripts:

create table flight_info(id int,source varchar(25),destination varchar(15));
insert into flight_info values(1,'Delhi','Kolkata')
insert into flight_info values(1,'Kolkata','Bangalore')
insert into flight_info values(2,'Mumbai','Pune')
insert into flight_info values(2,'Pune','Goa')
insert into flight_info values(3,'Kolkata','Delhi')
insert into flight_info values(3,'Delhi','Srinagar')

#sql
#plsql
#trend
#sqlqueryinterviewquestionsandanswers
#sqlinterview
#tcs
#infosys
#deloitte
#postgresql
#sqlserver
#oraclesql
#hcl
#2024
#2025
#india
#capgemini
#infosys
#hcl
#data engineer
#data analyst
#data science
#dbms
#rdbms
#datastructures

[reddymaestro]

your solutions are simple and straight forward ..very good

[DILLIPAKUMARCHOUDHARY]

SELECT ID, MAX(TT), MAX(TR) FROM(
SELECT ID, LAG(SOURCE)OVER(PARTITION BY ID ORDER BY ROWID)TT,
LEAD(DESTINATION) OVER(PARTITION BY ID ORDER BY ROWID)TR FROM FLIGHT_INFO) GROUP BY ID ;

[Vishal-ky]

Please guide me I am final year student I don't have any projects made, please tell what projects should Every fresher have to be in their for getting shortlisted

[vivekshirsat]

here is my solution


SELECT
DISTINCT id,
FIRST_VALUE(source)
OVER(partition by id order by id rows between unbounded preceding and unbounded following) as source,
LAST_VALUE(destination)
OVER(partition by id order by id rows between unbounded preceding and unbounded following) as destination
FROM flight_info;

[DILLIPAKUMARCHOUDHARY]

SELECT ID, MAX(TT), MAX(TR) FROM(
SELECT ID, LAG(SOURCE)OVER(PARTITION BY ID ORDER BY ROWID)TT,
LEAD(DESTINATION) OVER(PARTITION BY ID ORDER BY ROWID)TR FROM FLIGHT_INFO) GROUP BY ID ;