SQL - Query cities w/ shortest and longest names with length!!!

preview_player
Показать описание
Query cities w/ shortest and longest names with length using analytical functions!!!

This will use Microsoft Transact SQL along with some analytical functions. This may be a whiteboard type coding interview question for SQL developers.

Will use min and max to get the results.

My Social Links

Enjoy ;-)
  1. Joe
Рекомендации по теме
HackerRank Japanese Cities' 0:01:51

HackerRank Japanese Cities' Names Solution Explained - SQL

HackerRank SQL || 0:07:09

HackerRank SQL || Weather Observation Station 5 || SQL Learning

Shortest and longest 0:05:50

Shortest and longest length city | SQL Server |SQL Interview Preparation | Part 48

SQL Interview Question 0:06:08

SQL Interview Question # 18 - SQL Query to find City names having 5 letters and end the letter &apos...

SQL indexing best 0:04:08

SQL indexing best practices | How to make your database FASTER!

Advanced Aggregate Functions 0:06:00

Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)

HackerRank Revising the 0:04:16

HackerRank Revising the Select Query I Solution Explained - SQL

SQL Query to 0:00:55

SQL Query to get list of employees if per city employee count is two or more #shorts #sqlquery

3 Simple Steps 0:04:06

3 Simple Steps to Create Relations Between SQL Tables in SECONDS!

HackerRank SQL || 0:03:25

HackerRank SQL || Weather Observation Station 4 || SQL Learning

SQL in the 0:58:14

SQL in the City 2015 London - Uncovering SQL Server query problems with execution plans

SQL query to 0:01:57

SQL query to print names start with vowels || Hackerrank solution || vowels || vowels and consonants

How to get 0:00:27

How to get COUNT of DISTINCT VALUES in SQL

Data Analysis SQL 0:01:00

Data Analysis SQL Interview Questions | Running SUM | Who Hit the Sales Target First

Combine SQL Queries 0:05:04

Combine SQL Queries With UNION, INTERSECT, EXCEPT

Hackerrank African Cities 0:04:01

Hackerrank African Cities Asian Population Problem | SQL | Ashutosh Kumar

SQL | Count(*) 0:00:24

SQL | Count(*) vs Count(1) Vs Count(colname) #sqltips

#1 Revising the 0:02:31

#1 Revising the Select Query 1 | HackerRank SQL Solutions

SOLVE 5 SQL 0:05:02

SOLVE 5 SQL QUERIES IN 5 MINUTES (PART 1) | MASTER IN SQL | SQL INTERVIEW QUESTIONS

HackerRank weather observation 0:03:32

HackerRank weather observation station 5 Problem | SQL | Ashutosh Kumar

#13 Weather Observation 0:06:01

#13 Weather Observation Station 8 | HackerRank SQL Solutions

SQL Query To 0:00:20

SQL Query To Print the Details of Employees Whose first_name ends with 't' | #SQL #intervi...

What is CTE 0:00:53

What is CTE in SQL Server ?

Simple SQL code 0:00:17

Simple SQL code || Structured Query Language || SQL || RDBMS #programming