PostgreSQL query to return db records from the last X days, weeks or months
We always need to fetch some latest records from database and we often forget the query or too lazy to write it ourself and we search something like How to list records with date from the last 10 days
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Recent comments on sql
We can solve it without using join operator. I think it will help you. SELECT w.id,