SteemSQL Tutorial: How to Avoid SQL Injection?
My SteemSQL scripts suddenly stopped working a few hours ago and I thought at first it was the connectivity issues until I found out the same queries run just …
Tag: database
SteemSQL Tutorial: How to Get the Most Payout Authors in History?
@nationalpark has published quite a few posts on the most payout authors in history, and here is how it was done in SteemSQL just in case you want to …
Nth Highest Distinct Record using SQL
Write a SQL query to get the nth highest distinct salary from the Employee table. +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 | | 2 …
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 – 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. …