Search for a command to run...
Articles tagged with #sql
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 is separated by the ' ' character. Example: If file.txt has the following content: name age alice 2...
181. Employees Earning More Than Their Managers 題目敘述 SQL Schema > Create table If Not Exists Employee (id int, name varchar(255), salary int, managerId int) Truncate table Employee insert into Employee (id, name, salary, managerId) values ('1', 'Joe'...
180. Consecutive Numbers 題目敘述 SQL Schema > Create table If Not Exists Logs (id int, num int) Truncate table Logs insert into Logs (id, num) values ('1', '1') insert into Logs (id, num) values ('2', '1') insert into Logs (id, num) values ('3', '1') in...
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) values ('1', '3.5') insert into Scores (id, score) values ('2', '3.65') insert into Scores (id, sco...
177. Nth Highest Salary 題目敘述 SQL Schema > Create table If Not Exists Employee (Id int, Salary int) Truncate table Employee insert into Employee (id, salary) values ('1', '100') insert into Employee (id, salary) values ('2', '200') insert into Employe...
176. Second Highest Salary 題目敘述 SQL Schema > Create table If Not Exists Employee (id int, salary int) Truncate table Employee insert into Employee (id, salary) values ('1', '100') insert into Employee (id, salary) values ('2', '200') insert into Empl...