ONE SHOT Concept on SQL JOINS
HTML-код
- Опубликовано: 31 июл 2024
- This video covers the practical aspects of one of the most asked topis in interviews i.e. JOINS.
Here i have implemented all the five joins in SQL and explained them.
Do like, share and subscribe.
#sqldeveloper #sql #dataanalytics #dataengineering #placement #college #interviewquestions #sqlinterviewquestionsandanswers #facebook #amazon #flipkart #myntra #tcs #deloittejobs #accenture
bro provide your mail_id in the description so that we can send you the questions to you.
create table invoice
(
serial_no int,
invoice_date date
)
insert into invoice values (330115, '2024-03-01')
insert into invoice values (330120, '2024-03-01')
insert into invoice values (330121, '2024-03-01')
insert into invoice values (330122, '2024-03-02')
insert into invoice values (330125, '2024-03-02')
-- write a sql query to identify the missing serial no.
I had made a video regarding missing serial numbers, have a watch.