Data Semantics SQL Interview Question - REPLACE and LEN Functions in SQL
Автор: Cloud Challengers
Загружено: 2024-05-14
Просмотров: 4704
One of the SQL questions recently asked in Data Semantics interview.
Given us input table, we need to find the length of each record in the table.
In order to solve this questions, we used REPLACE() and LEN() Functions. You will understand how all these functions works in this video.
Let us first create input table
create table tbl_cnt (col1 int, col2 varchar(50))
Insert the records
insert into tbl_cnt values (1, 'a,b,c'),(2, 'a,b')
For more SQL interview questions. Check out our playlist.
• SQL Interview Questions
Contact us:
[email protected]
Follow us on
Instagram : instagram.com/cloudchallengers
Facebook : facebook.com/cloudchallengers
LinkedIn : linkedin.com/company/cloudchallengers
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
