SQL Learning 💻 @sql_codings Channel on Telegram

SQL Learning 💻

21 Jan, 14:08

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:

RANK:

Assigns unique numbers, and in the case of ties, rows get the same rank, and the next rank is skipped.

DENSE_RANK:

Assigns ranks to rows with tied values, without skipping the next rank

These 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.)

5,823

SQL Learning 💻

18 Apr, 20:32

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;

22,935

SQL Learning 💻

07 Sep, 03:02

https://dataengineeringacademy.medium.com/5-sql-queries-every-data-engineer-scientist-should-know-d68261167f1a

29,864

SQL Learning 💻

15 May, 05:40

https://towardsdatascience.com/mysql-vs-postgresql-3d48891452a

28,283

SQL Learning 💻

20 Feb, 05:24

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.

25,988

SQL Learning 💻

07 Dec, 01:05

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.

25,220

SQL Learning 💻

08 Aug, 16:09

You are given this database, your task is to output➡

22,041

SQL Learning 💻

22 Jul, 16:39

Write a sql query to find the Joining date of Employee in YYYY-DAY-Date format.

20,202

SQL Learning 💻

19 Jul, 07:32

Write a sql query to delete duplicate rows from a table.

19,792

SQL Learning 💻

18 Jul, 17:22

Write a sql query to find the second largest number from table table_name and column number.

19,309

SQL Learning 💻

13 Jul, 18:14

https://www.techonthenet.com/sql_server/functions/index.php

19,430

SQL Learning 💻

13 Jul, 18:13

http://www-db.deis.unibo.it/courses/TW/DOCS/w3schools/sql/sql_functions.asp.html

18,930

SQL Learning 💻

13 Jul, 18:11

https://docs.microsoft.com/en-us/sql/t-sql/lesson-1-creating-database-objects?view=sql-server-ver15

Start your tutorial here

17,605

SQL Learning 💻

13 Jul, 16:56

Find the Employees who hired in the Last n months. Write a SQL query for that.

Send your queries in the discussion group.

15,813

SQL Learning 💻

13 Apr, 03:26

Through this you can access a very good course on SQL for FREE.

15,138

SQL Learning 💻

13 Apr, 03:21

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

15,380

SQL Learning 💻

SQL Learning 💻 (English)

SQL Learning 💻

SQL Learning 💻

SQL Learning 💻

SQL Learning 💻

SQL Learning 💻

SQL Learning 💻

SQL Learning 💻

SQL Learning 💻

SQL Learning 💻

SQL Learning 💻

SQL Learning 💻

SQL Learning 💻

SQL Learning 💻

SQL Learning 💻

SQL Learning 💻

SQL Learning 💻

4,862

3

3

Best Similar Channel

Random Similar Channel