SQL Learning 💻
Open in Telegram
Learn SQL from Scratch! See also @C_codings, @Cpp_codings , @moreinfoaboutme
Show moreThe country is not specifiedTechnologies & Applications20 206
4 799
Subscribers
No data24 hours
+127 days
+1530 days
Data loading in progress...
Similar Channels
Tags Cloud
No data
Any problems? Please refresh the page or contact our support manager.
Incoming and Outgoing Mentions
---
---
---
---
---
---
Attracting Subscribers
December '24
December '24
+1
in 0 channels
November '24
+1
in 0 channels
Get PRO
October '24
+2
in 0 channels
Get PRO
September '24
+19
in 0 channels
Get PRO
August '24
+88
in 0 channels
Get PRO
July '240
in 0 channels
Get PRO
June '240
in 0 channels
Get PRO
May '24
+4
in 0 channels
Get PRO
April '24
+37
in 0 channels
Get PRO
March '24
+62
in 0 channels
Get PRO
February '24
+16
in 0 channels
Get PRO
January '24
+12
in 0 channels
Get PRO
December '23
+978
in 0 channels
Get PRO
November '230
in 0 channels
Get PRO
October '230
in 0 channels
Get PRO
September '230
in 0 channels
Get PRO
August '230
in 0 channels
Get PRO
July '230
in 0 channels
Get PRO
June '230
in 0 channels
Get PRO
May '230
in 0 channels
Get PRO
April '230
in 0 channels
Get PRO
March '230
in 0 channels
Get PRO
February '230
in 0 channels
Get PRO
January '230
in 0 channels
Get PRO
December '220
in 0 channels
Get PRO
November '22
+147
in 0 channels
Get PRO
October '22
+92
in 0 channels
Get PRO
September '22
+165
in 0 channels
Get PRO
August '22
+182
in 0 channels
Get PRO
July '22
+200
in 0 channels
Get PRO
June '22
+217
in 0 channels
Get PRO
May '22
+226
in 0 channels
Get PRO
April '22
+343
in 0 channels
Get PRO
March '22
+65
in 0 channels
Get PRO
February '22
+147
in 0 channels
Get PRO
January '22
+235
in 0 channels
Get PRO
December '21
+217
in 0 channels
Get PRO
November '21
+206
in 0 channels
Get PRO
October '21
+188
in 0 channels
Get PRO
September '21
+224
in 0 channels
Get PRO
August '21
+199
in 0 channels
Get PRO
July '21
+174
in 0 channels
Get PRO
June '21
+197
in 0 channels
Get PRO
May '21
+130
in 0 channels
Get PRO
April '21
+107
in 0 channels
Get PRO
March '21
+750
in 0 channels
| Date | Subscriber Growth | Mentions | Channels | |
| 11 December | 0 | |||
| 10 December | 0 | |||
| 09 December | 0 | |||
| 08 December | 0 | |||
| 07 December | 0 | |||
| 06 December | 0 | |||
| 05 December | 0 | |||
| 04 December | 0 | |||
| 03 December | 0 | |||
| 02 December | +1 | |||
| 01 December | 0 |
Channel Posts
When assigning unique identifiers to rows based on a specified order, three key functions come into play: ROW_NUMBER, RANK, and DENSE_RANK.
Consider the following table:
| Name | Score |
|-------- |-------|
| Alice | 90 |
| Bob | 90 |
| Carol | 85 |
| David | 78 |
ROW_NUMBER:
The simplest of the three, ROW_NUMBER assigns a unique number to each row based on the specified order. Each row receives a distinct identifier, incrementing by one.
Example:
1 2 3 4RANK: Assigns unique numbers, and in the case of ties, rows get the same rank, and the next rank is skipped.
1 1 3 4DENSE_RANK: Assigns ranks to rows with tied values, without skipping the next rank
1 1 2 3These functions help in organizing and analyzing data by providing distinct identifiers or ranks based on specified criteria. The example table illustrates how ROW_NUMBER, RANK, and DENSE_RANK operate in assigning order to rows with varying scores. (Note: This is 1/3 of the total number of articles; others are coming soon.)
| 2 | Here's a snippet of code written in C:
for(int i=0;i<n;i++)
{
for(int j=0;j<n;j++)
{
//some operation
}
}
How can I write something equivalent in SQL?
Solution:Alias
say, you are asked to count the frequency of each color occurring in the same table , so you can write something like this:
select distinct color ,(select count(*) from colors where c.color=color) from colors c; | 8 271 |
| 3 | https://dataengineeringacademy.medium.com/5-sql-queries-every-data-engineer-scientist-should-know-d68261167f1a | 6 723 |
| 4 | Solved_sql_sheet.pdf | 3 579 |
| 5 | Sql_cheatsheet.pdf | 986 |
| 6 | https://towardsdatascience.com/mysql-vs-postgresql-3d48891452a | 1 183 |
| 7 | https://play.google.com/store/apps/details?id=com.sololearn.sql
If you are starting with SQL and wish to code the queries as you learn more about SQL , Sololearn is perfect place for you. | 2 829 |
| 8 | https://www.udemy.com/course/the-complete-sql-course-2020-become-a-mysql-master/?couponCode=SQLCOURSE29
Get this course for free.
Just two days before it expires. | 3 835 |
| 9 |  No text... | 4 540 |
| 10 | You are given this database, your task is to output➡ | 4 132 |
| 11 | Write a sql query to find the Joining date of Employee in YYYY-DAY-Date format. | 3 838 |
| 12 | Write a sql query to delete duplicate rows from a table. | 3 639 |
| 13 | Write a sql query to find the second largest number from table table_name and column number. | 3 503 |
| 14 | SQL.pdf | 3 553 |
| 15 | https://www.techonthenet.com/sql_server/functions/index.php | 3 401 |
| 16 | http://www-db.deis.unibo.it/courses/TW/DOCS/w3schools/sql/sql_functions.asp.html | 3 170 |
| 17 | https://docs.microsoft.com/en-us/sql/t-sql/lesson-1-creating-database-objects?view=sql-server-ver15
Start your tutorial here | 2 987 |
| 18 | Find the Employees who hired in the Last n months. Write a SQL query for that.
Send your queries in the discussion group. | 2 709 |
| 19 | Through this you can access a very good course on SQL for FREE. | 2 958 |
| 20 | Hey everyone ! Been a long since I posted anything. I realised that providing all the details here is meaningless as there are many better resources out there !
Keeping that in mind
Here's something for you
To minimize the impact of coronavirus outbreak on students, Progate (an online coding learning platform from Japan) has shared free access to their learning platform for all students until *30th April 2020*.
You can utilize this time at home by learning new tech skills. This will not only help you to strengthen your programming skills but will also allow you to prepare for interviews and placements.
This access includes 14 detailed online lessons of Python, Go, SQL, Command-Line and Git.
*STEPS TO ACTIVATE YOUR ACCESS:*
1) Create your free account on progate.com
2) Open this link and click the 'Join' button: bit.ly/progatespecialaccessduetocovid19
3) Open bit.ly/progatespecialaccess from a laptop/desktop and select the language | 2 947 |
