#sql
Read more stories on Hashnode
Articles with this tag
194. Transpose File 題目敘述 Given a text file file.txt, transpose its content. You may assume that each row has the same number of columns and each field...
181. Employees Earning More Than Their Managers 題目敘述 SQL Schema > Create table If Not Exists Employee (id int, name varchar(255), salary int,...
180. Consecutive Numbers 題目敘述 SQL Schema > Create table If Not Exists Logs (id int, num int) Truncate table Logs insert into Logs (id, num) values...
178. Rank Scores 題目敘述 SQL Schema > Create table If Not Exists Scores (id int, score DECIMAL(3,2)) Truncate table Scores insert into Scores (id, score)...
177. Nth Highest Salary 題目敘述 SQL Schema > Create table If Not Exists Employee (Id int, Salary int) Truncate table Employee insert into Employee (id,...
176. Second Highest Salary 題目敘述 SQL Schema > Create table If Not Exists Employee (id int, salary int) Truncate table Employee insert into Employee...
