-- 数据集
USE MASTER
GO
IF EXISTS(SELECT * FROM SYSDATABASES WHERE name='LeetCode')
BEGIN
DROP DATABASE LeetCode
SELECT 1 AS deleted_leetcode
END
CREATE DATABASE LeetCode
USE LeetCode
GO
IF EXISTS(SELECT * FROM SYS.OBJECTS WHERE name='salesperson')
DROP TABLE salesperson
CREATE TABLE salesperson
(
sales_id INT IDENTITY,
name VARCHAR(15),
salary INT,
commission_rate INT,
hire_date DATE,
CONSTRAINT PK_sales PRIMARY KEY(sales_id)
)
INSERT INTO salesperson VALUES
sqlserver 三表联接(having + case clause用法一)
最新推荐文章于 2020-12-09 21:20:09 发布