55.Cognizant SQL Interview Questions For Experienced|SQL Tricky Interview Questions|

Подписаться 17 тыс.

Просмотров 2,5 тыс.

50% 1

To Join SQL Mastery Program: Website - www.studyitedu...
⚡ App: play.google.co...
Download files Discussed in this Video: www.studyitedu...
Any Questions not able to solve, Email: mpandeyguruji@gmail.com
Please subscribe to my other channel too: / studyiteducation
--------Connect on Social Media--------------------
LinkedIn: / mukesh-pandey-1a151634
Facebook: / mpandeyguruji
Instagram: / pandey_guruji
Whats App: whatsapp.com/c...
Telegram: t.me/pandeyguruji
---------------Top Playlist-----------------------------------------------------------------
SQL Tutorial for Beginners in Hindi: bit.ly/3CwfnGB
SQL Tutorial for Beginners in English: bit.ly/3qVI3GQ
SQL Practice Exercises with Solutions: bit.ly/3Eb5tNg
SQL Interview Questions: bit.ly/2CR6wCZ
Advanced SQL Interview Questions: bit.ly/3HnMrnN
Crack SQL Interview: bit.ly/3caxIyb
SQL Live Training: bit.ly/3kXqOl1
Career Guidance: bit.ly/3FffkRf
IT Technology News & Updates: bit.ly/3FeNQvc
---------------------------------------------------------------------------------------------------
#SQL #pandeyguruji ‪@cognizant‬#cognizant
sql interview questions for experienced
sql interview questions and answers for freshers
sql questions asked in interview
sql interview questions and answers
sql database developer interview questions
sql mock interview for freshers
sql tricky interview questions and answers
data analyst interview questions and answers sql
sql server interview questions and answers
business analyst sql interview questions
sql entry level interview questions
sql developer interviews
dbms interview questions for freshers
sql for interview in one video
sql interview questions and answers
sql questions asked in interview
sql interview questions and answers for freshers
sql tricky interview questions and answers
sql server interview questions and answers
sql database developer interview questions
data analyst interview questions and answers sql
sql mock interview for freshers
sql entry level interview questions
business analyst sql interview questions
amazon sql interview questions
python interview questions for experienced
sql for interview in one video
testing interview questions for experienced
manual interview questions for experienced
sql developer interviews
data analyst mock interview for experienced
qa interview questions and answers for experienced
oracle database interview questions
tell me about yourself interview for experienced
dbms interview questions for freshers
java experience interview questions and answers
database interview questions
interview preparation for experienced
interview questions and answers
python mock interview for experienced
selenium mock interview for experienced
java 8 interview questions for experienced
selenium interview questions and answers
doordash sql interview questions
java mock interview for experienced
analyst job interview questions
data analyst interview questions and answers
data analyst interview questions
analyst interview questions and answers
---------------------------------------------------------------------------------------------------
Disclaimer - This video is just for educational purposes.
Copyright Disclaimer under Section 107 of the Copyright Act 1976, allowance for the "fair use".
All the images, music, and graphics used in this video belong to their respective owners and I or this channel do not claim any right over them.
Copyright Disclaimer under section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, education, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing

Опубликовано:

28 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 6

@PandeyGuruji 2 месяца назад

Subscribe My Vlog Channel: www.youtube.com/@pandeygurujivlog Subscribe Technical Channel: ru-vid.com Facebook: facebook.com/pandeygurujivlog

@vijay.s-ll1yq 4 месяца назад

3.question query select id,min(date) from data_structre group by id

@vishalsonawane.8905 4 месяца назад

SELECT city, COUNT(*) AS Total_cnt, SUM(CASE WHEN gender = 'F' THEN 1 ELSE 0 END) AS Female_cnt, SUM(CASE WHEN gender = 'M' THEN 1 ELSE 0 END) AS Male_cnt FROM emp_info GROUP BY city;

@vijay.s-ll1yq 3 месяца назад

with cte as (select *, min(date) over (partition by id order by date rows between unbounded preceding and unbounded following) min_of_date from cognized_delete_data) delete from cte where date min_of_date

@vijay.s-ll1yq 4 месяца назад

1. question inner join no.of rows -4 left join no.of rows -6 right join no.of rows -6 2 question query with cte as (select *, sum(case when gender ='F' then 1 else 0 end) over (partition by city) as Female_cnt, sum(case when gender ='M' then 1 else 0 end) over (partition by city) as Male_cnt from gender), cte2 as (select city,Female_cnt, Male_cnt ,count(1) as Total_cnt from cte group by city,Female_cnt, Male_cnt) select City,total_cnt,Male_cnt,Female_cnt from cte2

@vishalsonawane.8905 4 месяца назад

Incomplete video until u provide & add the DDL DML command ,SQL query solution in description