In SQL, What is the purpose of DENSE_RANK()? ๐ฅ๐ก๐จ ๐๐๐ฝ๐๐พ๐๐๐ฝ๐, ๐๐ฉ ๐๐๐ฉ ๐๐จ ๐๐๐ก๐ฅ
Show more
8 hours ago โข Rajesh UmraoโData&AI
Assign unique numbers to every row
Assign rankings without gaps after ties
Sort rows alphabetically
Remove duplicate rows
338 answered
2
0
8 hours ago โข Rajesh UmraoโData&AI
https://www.instagram.com/p/DdolSC5k0... ๐ฅ๐ก๐จ ๐๐๐ฝ๐๐พ๐๐๐ฝ๐, ๐๐ฉ ๐๐๐ฉ ๐๐จ ๐๐๐ก๐ฅ
14
0
1 day ago (edited) โข Rajesh UmraoโData&AI
https://www.instagram.com/p/DdmAgjhk-... ๐ฅ๐ก๐จ ๐๐๐ฝ๐๐พ๐๐๐ฝ๐, ๐๐ฉ ๐๐๐ฉ ๐๐จ ๐๐๐ก๐ฅ
34
0
1 day ago โข Rajesh UmraoโData&AI
What is conditional aggregation in SQL? ๐ฅ๐ก๐จ ๐๐๐ฝ๐๐พ๐๐๐ฝ๐, ๐๐ฉ ๐๐๐ฉ ๐๐จ ๐๐๐ก๐ฅ
Aggregating only rows satisfying a condition
Aggregating only NULL values
Grouping tables before joining
Aggregating columns alphabetically
839 answered
10
0
2 days ago โข Rajesh UmraoโData&AI
Which SQL concept allows a query to return different columns depending on conditions? ๐ฅ๐ก๐จ ๐๐๐ฝ๐๐พ๐๐๐ฝ๐, ๐๐ฉ ๐๐๐ฉ ๐๐จ ๐๐๐ก๐ฅ
CASE
GROUP BY
DISTINCT
ORDER BY
978 answered
8
0
2 days ago (edited) โข Rajesh UmraoโData&AI
https://www.instagram.com/p/DdjbtDqk_... ๐ฅ๐ก๐จ ๐๐๐ฝ๐๐พ๐๐๐ฝ๐, ๐๐ฉ ๐๐๐ฉ ๐๐จ ๐๐๐ก๐ฅ
33
0
3 days ago โข Rajesh UmraoโData&AI
https://www.instagram.com/p/Ddg27uqE9... ๐ฅ๐ก๐จ ๐๐๐ฝ๐๐พ๐๐๐ฝ๐, ๐๐ฉ ๐๐๐ฉ ๐๐จ ๐๐๐ก๐ฅ
40
0
3 days ago โข Rajesh UmraoโData&AI
In SQL, What does EXISTS primarily test? ๐ฅ๐ก๐จ ๐๐๐ฝ๐๐พ๐๐๐ฝ๐, ๐๐ฉ ๐๐๐ฉ ๐๐จ ๐๐๐ก๐ฅ
Whether a subquery returns a specific value
Whether a subquery returns at least one row
Whether two tables have identical columns
Whether a column contains NULL
981 answered
13
0
4 days ago (edited) โข Rajesh UmraoโData&AI
Don't miss updates.. Join me on WhatsApp https://whatsapp.com/channel/0029VbBM...
6
0