Infosys SQL Interview Question
SQL questions recently asked in Infosys interview. We need to find origin and final destination details.
To find out the expected output, I use joins.
--Create table syntax
CREATE TABLE Flights (cust_id INT, flight_id VARCHAR(10), origin VARCHAR(50), destination VARCHAR(50));
-- Insert data into the table
INSERT INTO Flights (cust_id, flight_id, origin, destination)
VALUES (1, 'SG1234', 'Delhi', 'Hyderabad'), (1, 'SG3476', 'Kochi', 'Mangalore'), (1, '69876', 'Hyderabad', 'Kochi'), (2, '68749', 'Mumbai', 'Varanasi'), (2, 'SG5723', 'Varanasi', 'Delhi');
For more SQL interview questions. Check out our playlist.
• SQL Interview Questions
Contact us:
info@cloudchallengers.com
Follow us on
Instagram : instagram.com/cloudchallengers
Facebook : facebook.com/cloudchallengers
LinkedIn : linkedin.com/company/cloudchallengers
On this page of the site you can watch the video online Infosys SQL Interview Question with a duration of hours minute second in good quality, which was uploaded by the user Cloud Challengers 01 September 2024, share the link with friends and acquaintances, this video has already been watched 95,683 times on youtube and it was liked by 1.8 thousand viewers. Enjoy your viewing!
