Better SQL Insert Syntax
The SQL Insert statement is used when you want to insert new rows of data into the existing tables. For example, if a table has fields A, B, C …
Category: sql
Send Emails using Crontab for Your Web Applications
In your web applications, sometimes you would need to send users tons of emails. You can send them real time when users e.g. press a send button. But this …
SQL Coding Exercise – Delete Duplicate Emails
Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id. +----+------------------+ | Id | Email …
SQL Coding Exercise – Rising Temperature
Given a Weather table, write a SQL query to find all dates’ Ids with higher temperature compared to its previous (yesterday’s) dates. +---------+------------+------------------+ | Id(INT) | Date(DATE) | Temperature(INT) …
SQL Coding Exercise – Rank Scores
Submit your SQL to Leetcode online judge: https://oj.leetcode.com/problems/rank-scores/ Write a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. …