SQL Interview Questions And Answers Part 61 | SQL questions for Product based companies
SQL Interview Questions And Answers Part 61
This question has been asked in many company and it will be helpful in cracking any SQL interview
Problem Statement : Device Table consists of Device_id and Locations.
Write a SQL query to get the output as shown in video :-
-------------------------------------------------------------------------
𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥
-------------------------------------------------------------------------
*Instagram :
/ itjunction4all
*Twitter:
/ sunilkr5672
-------------------------------------------------------------------------
Table and Insert SQL Script :
-------------------------------------------------------------------------
Create Table Device(
Device_id int,
Locations Varchar(25)
)
Insert into Device (Device_id,Locations) values
(12,'Bangalore'),
(12,'Bangalore'),
(12,'Bangalore'),
(12,'Bangalore'),
(12,'Hosur'),
(12,'Hosur'),
(13,'Hyderabad'),
(13,'Hyderabad'),
(13, 'Secunderabad'),
(13, 'Secunderabad'),
(13, 'Secunderabad')
#WALMARTInterview #FAANG #SQLInterviewQuestionsandanswers #sqlInterviewQuestions #MAANG #sqlInterviewQuestionsForTesting
Watch video SQL Interview Questions And Answers Part 61 | SQL questions for Product based companies online without registration, duration hours minute second in high quality. This video was added by user ItJunction4all 27 March 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,62 once and liked it 7 people.