Learned or Solved Something Today?

Dump it here! Let others learn from you

Write a sql hack
Showing 20 of 73 from page 1

metabox posted in #sql #postgresql #snippets

How To Extract Domain Name From Email Address | PostgreSQL SELECT Query

In this simple SQL query we will see how to select domain name from email address. Extract domain In postgres we can simply use split part function which splits a string on a specified delimiter and r

metabox posted in #sql #postgresql #snippets

SQL Query To Extract URL / Link From Text Content Of Postgres Database Table | Regex Extractor

In this post we will see how simple it is to extract a URL or a link from your text or character varying content. In this example I am using regex for postgres database. Query Simply we are going to u

metabox posted in #sql #tutorial #mysql #cheatsheet

Quick SQL Cheatsheet With Examples Queries - Beginners To Interview Prep

A quick SQL cheat sheet of all relevant SQL queries and examples with quick guide how to use them such as Finding Data Queries Data Modification Queries Reporting Queries Join Queries View Queries Alt

metabox posted in #sql #hackerrank-solutions #codingchallenge #github #mysql

SQL Solution For HackerRank Problem: Ollivander's Inventory

Ollivander s Inventory is another HackerRank problem from Basic Join Category Here is the SQL solution in MySQL environment Problem Description Harry Potter and his friends are at Ollivander s with Ro

metabox posted in #sql #hackerrank-solutions #codingchallenge #github #mysql

SQL Solution For HackerRank Problem: Top Competitors

Top Competitors is another HackerRank problem from Basic Join Category Here is the SQL solution in MySQL environment Problem Description Julia just finished conducting a coding contest and she needs y

metabox posted in #sql #hackerrank-solutions #codingchallenge #github #mysql

SQL Solution For HackerRank Problem: The Report

The Report is another HackerRank problem from Basic Join Category Here is the SQL solution in MySQL environment Problem Description Ketty gives Eve a task to generate a report containing three columns

metabox posted in #sql #hackerrank-solutions #codingchallenge #github #mysql

SQL Solution For HackerRank Problem: Average Population of Each Continent

Average Population of Each Continent is another HackerRank problem from Basic Join Category Here is the SQL solution in MySQL environment Problem Description Given the CITY and COUNTRY tables query th

metabox posted in #sql #hackerrank-solutions #codingchallenge #github #mysql

SQL Solution For HackerRank Problem: African Cities

African Cities is another HackerRank problem from Basic Join Category Here is the SQL solution in MySQL environment Problem Description Given the CITY and COUNTRY tables query the names of all cities

metabox posted in #sql #hackerrank-solutions #codingchallenge #github #mysql

SQL Solution For HackerRank Problem: Asian Population

Asian Population is another HackerRank problem from Basic Join Category Here is the SQL solution in MySQL environment Problem Description Given the CITY and COUNTRY tables query the sum of the populat

metabox posted in #sql #hackerrank-solutions #codingchallenge #github #mysql

SQL Solution For HackerRank Problem: Weather Observation Station 20

Weather Observation Station 20 is another HackerRank problem from Aggregation Challenges Category Here is the SQL solution in MySQL environment Problem Description A median is defined as a number sepa

metabox posted in #sql #hackerrank-solutions #codingchallenge #github #mysql

SQL Solution For HackerRank Problem: Weather Observation Station 19

Weather Observation Station 19 is another HackerRank problem from Aggregation Challenges Category Here is the SQL solution in MySQL environment Problem Description Consider P1 a c and P2 b d  to be tw

metabox posted in #sql #hackerrank-solutions #codingchallenge #github #mysql

SQL Solution For HackerRank Problem: Weather Observation Station 18

Weather Observation Station 18 is another HackerRank problem from Aggregation Challenges Category Here is the SQL solution in MySQL environment Problem Description Consider P1 a b  and p2 c d  to be t

metabox posted in #sql #hackerrank-solutions #codingchallenge #github #mysql

SQL Solution For HackerRank Problem: Weather Observation Station 17

Weather Observation Station 17 is another HackerRank problem from Aggregation Challenges Category Here is the SQL solution in MySQL environment Problem Description Query the Western Longitude LONG W w

metabox posted in #sql #hackerrank-solutions #codingchallenge #github #mysql

SQL Solution For HackerRank Problem: Weather Observation Station 16

Weather Observation Station 16 is another HackerRank problem from Aggregation Challenges Category Here is the SQL solution in MySQL environment Problem Description Query the smallest Northern Latitude

metabox posted in #sql #hackerrank-solutions #codingchallenge #github #mysql

SQL Solution For HackerRank Problem: Weather Observation Station 15

Weather Observation Station 15 is another HackerRank problem from Aggregation Challenges Category Here is the SQL solution in MySQL environment Problem Description Query the Western Longitude LONG W f

metabox posted in #sql #hackerrank-solutions #codingchallenge #github #mysql

SQL Solution For HackerRank Problem: Weather Observation Station 14

Weather Observation Station 14 is another HackerRank problem from Aggregation Challenges Category Here is the SQL solution in MySQL environment Problem Description Query the greatest value of the Nort

metabox posted in #sql #hackerrank-solutions #codingchallenge #github #mysql

SQL Solution For HackerRank Problem: Weather Observation Station 13

Weather Observation Station 13 is another HackerRank problem from Aggregation Challenges Category Here is the SQL solution in MySQL environment Problem Description Query the sum of Northern Latitudes 

metabox posted in #sql #hackerrank-solutions #codingchallenge #github #mysql

SQL Solution For HackerRank Problem: Weather Observation Station 2

Weather Observation Station 2 is another HackerRank problem from Aggregation Challenges Category Here is the SQL solution in MySQL environment Problem Description Query the following two values from t

metabox posted in #sql #hackerrank-solutions #codingchallenge #github #mysql

SQL Solution For HackerRank Problem: The Blunder

The Blunder is another HackerRank problem from Aggregation Challenges Category Here is the SQL solution in MySQL environment Problem Description Samantha was tasked with calculating the average monthl

metabox posted in #sql #hackerrank-solutions #codingchallenge #github #mysql

SQL Solution For HackerRank Problem: Population Density Difference

Population Density Difference is another HackerRank problem from Aggregation Challenges Category Here is the SQL solution in MySQL environment Problem Description Query the difference between the maxi

fb