Тёмный

SQL Interview Questions and Answers Part-1 | Proc SQL 

SAS World
Подписаться 3,3 тыс.
Просмотров 2,7 тыс.
50% 1

SQL Interview Questions and Answers | Proc SQL
This Video contains Interview questions on Proc SQL.
Key Questions:
Time Topics
MM:SS
00:23 Find out the third highest MSRP in sashelp.cars data?
04:25 Create emp_count variable in sashelp.cars and assign value 1 in sashelp.cars dataset using Proc SQL query?
05:29 In below query what is the use of group by Clause?
06:33 In below query what is the use of summary function without group by clause?
07:25 If we run below two queries will there be any difference in output?
Contact details:
officialsasworld@gmail.com

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

 

22 апр 2023

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 7   
@BHARATHEEYUDU.
@BHARATHEEYUDU. Год назад
Thank for sharing questions
@ajaykushwaha4233
@ajaykushwaha4233 Год назад
Excellent very useful
@malcorub
@malcorub 2 месяца назад
Q2 was too easy, but for some reason the variable name EMP_COUNT confused me lol. Sounds too much like employee count. Great videos my friend.
@RajeshKumar-ux1tw
@RajeshKumar-ux1tw Год назад
Very nice and informative video for me❤❤❤
@173Himanshu
@173Himanshu Год назад
Very informative sir 😊
@deepakbatham1027
@deepakbatham1027 Год назад
Very nice...I have more ways to know 3rd highest way by using subquery..but this video I learn a another way to get same .. thankyou
@ajaykushwaha4233
@ajaykushwaha4233 Год назад
For question 1 I think it will not work for data set with duplicate values.
Далее
SQL Interview Questions and Answers Part -2 | Proc SQL
13:55
Top 25 SQL Interview Questions with Explanations
1:30:28
SAS Interview Questions on Functions | SAS Functions
10:40