- 20
- 30 630
Coding Lake
India
Приєднався 11 сер 2023
Hi Myself Shubham Saha MCA Graduate.
In This Channel I will Upload All Computer Related Topic's Like Computer Basic To Advance Concept.
If You Like My Content Please Like Share And Subscribe To My Channel.
Thank You For Visiting My Channel.
In This Channel I will Upload All Computer Related Topic's Like Computer Basic To Advance Concept.
If You Like My Content Please Like Share And Subscribe To My Channel.
Thank You For Visiting My Channel.
SQL Interview Question | accenture #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 office ( emp_id int
, emp_status varchar(10)
, time_id datetime);
insert into office values ('1', 'in', '2023-12-22 09:00:00');
insert into office values ('1', 'out', '2023-12-22 09:15:00');
insert into office values ('2', 'in', '2023-12-22 09:00:00');
insert into office values ('2', 'out', '2023-12-22 09:15:00');
insert into office values ('2', 'in', '2023-12-22 09:30:00');
insert into office values ('3', 'out', '2023-12-22 09:00:00');
insert into office values ('3', 'in', '2023-12-22 09:15:00');
insert into office values ('3', 'out', '2023-12-22 09:30:00');
insert into office values ('3', 'in', '2023-12-22 09:45:00');
insert into office values ('4', 'in', '2023-12-22 09:45:00');
insert into office values ('5', 'out', '2023-12-22 09:40:00');
like share , subscribe and comment down below..
if you have any suggestion or doubt this video.
scripts:
create table office ( emp_id int
, emp_status varchar(10)
, time_id datetime);
insert into office values ('1', 'in', '2023-12-22 09:00:00');
insert into office values ('1', 'out', '2023-12-22 09:15:00');
insert into office values ('2', 'in', '2023-12-22 09:00:00');
insert into office values ('2', 'out', '2023-12-22 09:15:00');
insert into office values ('2', 'in', '2023-12-22 09:30:00');
insert into office values ('3', 'out', '2023-12-22 09:00:00');
insert into office values ('3', 'in', '2023-12-22 09:15:00');
insert into office values ('3', 'out', '2023-12-22 09:30:00');
insert into office values ('3', 'in', '2023-12-22 09:45:00');
insert into office values ('4', 'in', '2023-12-22 09:45:00');
insert into office values ('5', 'out', '2023-12-22 09:40:00');
Переглядів: 992
Відео
SQL Interview Question | Amazon #dataengineering | #dataanalyst | #powerbi | #sql #dataengineer
Переглядів 1,2 тис.9 годин тому
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 emp( emp_id int NULL, emp_name varchar(20) NULL, salary int NULL, gender char(1) NULL ) insert into emp VALUES (1, 'Rajesh', 1000, 'M') insert into emp VALUES (1, 'Rajesh', 1000, 'M') insert into emp VALUES (2, 'Yogesh', 1500, 'M') insert into emp V...
SQL Interview Question | Genpact #dataengineering | #dataanalyst | #powerbi | #sql
Переглядів 4,6 тис.16 годин тому
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 office( emp_id int, experience [varchar](20) , [salary] [int] ) INSERT INTO office VALUES (1, 'Junior', 10000) INSERT INTO office VALUES (2, 'Junior', 15000) INSERT INTO office VALUES (3, 'Junior', 40000) INSERT INTO office VALUES (4, 'Senior', 1600...
consecutive free seat | SQL Interview Question | #dataengineering | #dataanalyst | #powerbi |
Переглядів 1,2 тис.21 годину тому
If you like this video please like share , subscribe and comment down below.. if you have any suggestion or doubt this video. script CREATE TABLE hall_ticket( id int, seat_id int, ) INSERT INTO hall_ticket VALUES (1, 1) INSERT INTO hall_ticket VALUES (2, 0) INSERT INTO hall_ticket VALUES (3, 1) INSERT INTO hall_ticket VALUES (4, 1) INSERT INTO hall_ticket VALUES (5, 1) INSERT INTO hall_ticket V...
RANK, DENSE_RANK, ROW_NUMBER | Window Function In SQL | #dataanalyst | #dataengineer | #powerbi
Переглядів 294День тому
If you like this video please like share , subscribe and comment down below.. if you have any suggestion or doubt this video. Script: create table emp(id int identity,name varchar(10),salary int) insert into emp values('ram',100) insert into emp values('shyam',100) insert into emp values('john',120) insert into emp values('shubham',130) insert into emp values('yash',140) insert into emp values(...
Custom Sort In SQL | Most Important Interview Question | #powerbi #dataengineering #dataanalyst
Переглядів 1,3 тис.14 днів тому
If you like this video please like share , subscribe and comment down below.. if you have any suggestion or doubt this video. dataset link: github.com/PhilippeCodes/World-Happiness-Report-Data-Analysis/blob/master/World Happiness Report.csv
TOP 5 SQL Interview Question Part 2 | #powerbi #dataengineering #dataanalyst
Переглядів 80614 днів тому
If you like this video please like share , subscribe and comment down below.. if you have any suggestion or doubt this video. Script: CREATE TABLE emp( emp_id int NULL, emp_name varchar(20) NULL, salary int NULL, dob date NULL, sample_str varchar(20) NULL, dept varchar(20) NULL, gender char(1) NULL ) insert into emp VALUES (1, 'Rajesh', 1000, '1996-02-05', 'co_helper', 'sales', 'M') insert into...
SQL Interview Question With Max and Min Function | #powerbi | #dataengineer #sql
Переглядів 1,8 тис.21 день тому
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 city_info(id int,state varchar(15),city varchar(10),population int); insert into city_info values(1,'Maharashtra','Mumbai',1000) insert into city_info values(2,'Maharashtra','Pune',500) insert into city_info values(3,'Maharashtra','Nagpur',400) inse...
TOP 5 SQL Interview Question | #powerbi #dataengineering #dataanalyst
Переглядів 1,2 тис.21 день тому
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 emp( emp_id int NULL, emp_name varchar(20) NULL, salary int NULL, dob date NULL ) INSERT into emp VALUES (1, 'Rajesh', 1000, '1996-02-05' ) INSERT into emp VALUES (1, 'Rajesh', 1000, '1996-02-05' ) INSERT into emp VALUES (2, 'Yogesh', 1500, '1997-10...
SQL Interview Question | Flipkart | #dataengineering #powerbi #dataanalyst
Переглядів 1 тис.28 днів тому
If you like this video please like share , subscribe and comment down below.. if you have any suggestion or doubt this video. SQL Scripts: create table employee_info(emp_id varchar(10),company varchar(10),salary int,dept varchar(10)); insert into employee_info values('emp1','X',1000,'Sales') insert into employee_info values('emp2','X',1020,'IT') insert into employee_info values('emp3','X',870,'...
SQL Interview Question | Infosys | Data Engineer
Переглядів 6 тис.Місяць тому
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 val...
SQL Interview Question | Capgemini | Data Engineer
Переглядів 8 тис.Місяць тому
If you like this video please like share , subscribe and comment down below.. if you have any suggestion or doubt this video. Script: CREATE TABLE Employee ( id INT PRIMARY KEY, name VARCHAR(50), department VARCHAR(50), managerId INT ); INSERT INTO Employee (id, name, department, managerId) VALUES (1, 'John', 'HR', NULL), (2, 'Bob', 'HR', 1), (3, 'Olivia', 'HR', 1), (4, 'Emma', 'Finance', NULL)...
Convert Unpivot table to pivot table in Sql #sql
Переглядів 2,6 тис.Місяць тому
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 emp ( emp_id int, salary_component_type varchar(20), val int ); insert into emp values (1,'salary',10000),(1,'bonus',5000),(1,'hike_percent',10) , (2,'salary',15000),(2,'bonus',7000),(2,'hike_percent',8) , (3,'salary',12000),(3,'bonus',6000),(3,'hike...
Zomato Sql Interview Question | SQL
Переглядів 1,3 тис.2 місяці тому
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 source(id int, name varchar(5)) create table target(id int, name varchar(5)) insert into source values(1,'A'),(2,'B'),(3,'C'),(4,'D') insert into target values(1,'A'),(2,'B'),(4,'X'),(5,'F'); #coding #sqlqueryinterviewquestionsandanswers #sql #sqlse...
SQL Interview Question | Amazon | Series 06
Переглядів 2503 місяці тому
If you like this video please like share , subscribe and comment down below.. if you have any suggestion or doubt this video. SQL Scripts: create table hotel_rooms ( user_id int, date_searched date, filter_room_types varchar(200) ); insert into hotel_rooms values (1,'2022-01-01','entire home,private room') ,(2,'2022-01-02','entire home,shared room') ,(3,'2022-01-02','private room,shared room') ...
SQL Interview Question | BookMyShow | Series 05
Переглядів 1833 місяці тому
SQL Interview Question | BookMyShow | Series 05
SQL Interview Question | Deloitte | Series 04
Переглядів 2373 місяці тому
SQL Interview Question | Deloitte | Series 04
SQL Interview Question | TCS | Series 03
Переглядів 2263 місяці тому
SQL Interview Question | TCS | Series 03
SQL Interview Question | PWC | Series 02
Переглядів 2043 місяці тому
SQL Interview Question | PWC | Series 02
SQL Interview Question | TCS | Series 01
Переглядів 2333 місяці тому
SQL Interview Question | TCS | Series 01