LeetCode – Consecutive Numbers
Question Write a SQL query to find all numbers that appear at least three times consecutively in the Logs table.Return the result in any order.… Read More »LeetCode – Consecutive Numbers
Home »
SQL Leet Code
LeetCode – Combine two tables
Question Write a SQL query to report the first name, last name, city, and state of each person in the Person table. If a person’s… Read More »LeetCode – Combine two tables
SQL Leet Code Nth Highest Salary Problem
Write an SQL query to report the nth highest salary from the Employee table. If there is no nth highest salary, the query should report null. Source:… Read More »SQL Leet Code Nth Highest Salary Problem
SQL LeetCode Rank Scores Problem
SQL LeetCode problem: Rank Scores Source: LeetCode Write an SQL query to rank the scores. The ranking should be calculated according to the following rules:… Read More »SQL LeetCode Rank Scores Problem