Accenture SQL Interview Question | Database Case Sensitivity vs Insensitivity
In this video we will discuss a Accenture SQL interview question and solve it when the data is case sensitive and when it is insensitivity .
Here is the script:
CREATE TABLE employees (employee_id int,employee_name varchar(15), email_id varchar(15) );
delete from employees;
INSERT INTO employees (employee_id,employee_name, email_id) VALUES ('101','Liam Alton', 'li.al@abc.com');
INSERT INTO employees (employee_id,employee_name, email_id) VALUES ('102','Josh Day', 'jo.da@abc.com');
INSERT INTO employees (employee_id,employee_name, email_id) VALUES ('103','Sean Mann', 'se.ma@abc.com');
INSERT INTO employees (employee_id,employee_name, email_id) VALUES ('104','Evan Blake', 'ev.bl@abc.com');
INSERT INTO employees (employee_id,employee_name, email_id) VALUES ('105','Toby Scott', 'jo.da@abc.com');
INSERT INTO employees (employee_id,employee_name, email_id) VALUES ('106','Anjali Chouhan', 'JO.DA@ABC.COM');
INSERT INTO employees (employee_id,employee_name, email_id) VALUES ('107','Ankit Bansal', 'AN.BA@ABC.COM');
ALTER TABLE employees
ALTER COLUMN email_id VARCHAR(15) COLLATE SQL_Latin1_General_CP1_CS_AS;
Zero to hero(Advance) SQL Aggregation:
• All About SQL Aggregations | SQL Advance |...
Most Asked Join Based Interview Question:
• Most Asked SQL JOIN based Interview Questi...
Solving 4 Trick SQL problems:
• Solving 4 Tricky SQL Problems
Data Analyst Spotify Case Study:
• Data Analyst Spotify Case Study | SQL Inte...
Top 10 SQL interview Questions:
• Top 10 SQL interview Questions and Answers...
Interview Question based on FULL OUTER JOIN:
• SQL Interview Question Based on Full Outer...
Playlist to master SQL :
• Complex SQL Questions for Interview Prepar...
Rank, Dense_Rank and Row_Number:
• RANK, DENSE_RANK, ROW_NUMBER SQL Analytica...
#sql #dataanalytics
On this page of the site you can watch the video online Accenture SQL Interview Question | Database Case Sensitivity vs Insensitivity with a duration of hours minute second in good quality, which was uploaded by the user Ankit Bansal 05 June 2024, share the link with friends and acquaintances, this video has already been watched 50,094 times on youtube and it was liked by 1 thousand viewers. Enjoy your viewing!
