sqlserver 查询练习

最新推荐文章于 2024-03-19 11:14:27 发布
VIP文章 最新推荐文章于 2024-03-19 11:14:27 发布
阅读量559 收藏 1
点赞数
分类专栏： SQL
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43650411/article/details/101689415
版权

目录

  • 数据集
  • eg.1
  • eg.2
  • eg.3
    在这里插入图片描述在这里插入图片描述
-- 数据集

/* 销售分析 */
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='Product')
	DROP TABLE Product
CREATE TABLE Product
(
	product_id  INT PRIMARY KEY,
	product_name  VARCHAR(20),
	unit_price  INT
)
INSERT INTO Product VALUES
	-- (1, 'S8', 1000), (2, 'G4', 800), (3, 'iPhone', 1400)
	(1,'v',483),(2,'jfrkzmmkoo',797),(3,'ujykl',1745),(4,'btmwpadknq',516),(5,'udmznzsra',573),(6,'uksl',819),(7,'sqsbnzsv',1750),(8,'quvwyl',1559),(9,'fvsh',1738),(10,'qerbdrvj',1535),(11,'hzvah',666),(12,'aal',1168),(13,'gruns',140),(14,'vx',118),(15,'jzojymmu',1244),(16,'iPhone',1671),(17,'gffqywcdo',372),(18,'cyjwtmt',929),(19,'n',1886),(20,'w',514),(21,'knvnewti',818),(22,'ctpwdf',853),(23,'lpyontofln',433),(24,'cjsjqokd',1042),(25,'ghfk',609),(26,'nb',688),(27,'bwmqpbcwte',721),(28,'xp',875),(29,'bmnvfgga',1248),(30,'vwi',1066),(31,'uhc',407),(32,'aeo',121),(33,'e',1896),(34,'v',1269),(35,'ah',562),(36,'kgda',1418),(37,'mpagcdoyea',1064),(38,'norrpnmv',356),(39,'S8',1583),(40,'upkikw',1178),(41,'vwru',1791),(42,'noktyjrgsh',597),(43,'ba',533),(44,'ksepshidwk',1167),(45,'xsmu',1957),(46,'otvdehgwwb',202),(47,'cdpedt',1343),(48,'gcu',726),(49,'debitkp',807),(50,'gujxmhcubz',1043)
GO

IF EXISTS(SELECT * FROM SYS.OBJECTS WHERE name='Sales')
	DROP TABLE Sales
CREATE TABLE Sales
(
	seller_id  INT,
	product_id  INT,
	buyer_id  INT,
	sale_date DATE,
	quantity  INT,
	price  INT,
	CONSTRAINT FK_product FOREIGN KEY(product_id) REFERENCES Product(product_id)
)
INSERT INTO Sales VALUES
	/*
	(1, 1, 1, '2019-01-21', 2, 2000),
	(1, 2, 2, '2019-02-17', 1, 800),
	--(2, 1, 3, '2019-06-02', 1, 800),
	(2, 3, 3, '2019-06-02', 1, 800),
	--(3, 3, 3, '2019-05-13', 2, 2800)
	(3, 3, 4, '2019-05-13', 2, 2800)
	*/
	(7,11,49,'2019-01-21',5,3330),(13,32,6,'2019-02-10',9,1089),(50,47,4,'2019-01-06',1,1343),(45,44,3,'2019-02-06',3,3501),(23,32,13,'2019-03-04',3,363),(35,18,48,'2019-01-08',10,9290),(28,19,44,'2019-01-06',2,3772),(46,35,5,'2019-03-15',10,5620),(34,7,33,'2019-02-07',10,17500),(47,14,42,'2019-02-01',5,590),(50,36,48,'2019-01-04',5,7090),(35,48,41,'2019-03-15',10,7260),(22,12,44,'2012-06-19',7,8176),(25,1,10,'2019-03-13',10,4830),(47,39,8,'2017-05-09',1,1583),(48,18,17,'2019-01-29',8,7432),(32,17,1,'2019-03-13',2,744),(31,20,36,'2019-03-22',5,2570),(38,38,40,'2019-01-27',6,2136),(48,40,50,'2019-02-17',1,1178),(13,14,29,'2019-02-01',1,118),(40,10,20,'2019-03-22',5,7675),(39,50,45,'2019-03-02',6,6258),(32,28,33,'2018-06-04',10,8750),(42,37,41,'2016-04-12',10,10640),(5,9,19,'2019-02-16',7,12166),(27,30,27,'2019-03-22',8,8528),(23,17,22,'2019-01-24',2,744),(39,42,5,'2019-03-26',8,4776),(13,25,9,'2019-02-25',4,2436),(26,45,1,'2019-01-24',4,7828),(9,3,48,'2016-01-23',3,5235),(19,50,43,'2019-03-25',10,10430),(20,4,41,'2019-01-15',4,2064),(30,30,16,'2019-02-10',9,9594),(4,4,22,'2019-02-23',2,1032),(16,12,25,'2012-11-24',1,1168),(38,4,4,'2019-03-09',1,516),(32,39,50,'2012-01-30',1,1583),(4,6,12,'2019-03-25',3,2457),(30,46,45,'2018-02-15',6,1212),(17,1,10,'2019-02-11',2,966),(22,28,17,'2009-01-29',9,7875),(44,2,32,'2019-03-09',5,3985),(16,45,9,'2019-01-31',10,19570),(21,46,44,'2009-02-22',5,1010),(31,1,44,'2019-02-16',3,1449),(20,50,27,'2019-03-15',4,4172),(12,1,29,'2019-02-06',4,1932),(17,24,40,'2010-08-23',2,2084),(44,43,12,'2018-12-17',9,4797),(8,43,20,'2009-04-17',4,2132),(49,20,21,'2019-02-18',1,514),(24,48,5,'2019-03-08',6,4356),(3,31,29,'2008-06-26',8,3256),(17,43,17,'2011-12-10',1,533),(43,45,9,'2019-03-26',6,11742),(48,41,35,'2019-01-29',7,12537),(45,1,1,'2019-01-07',8,3864),(1,34,12,'2019-03-21',6,7614),(34,27,11,'2019-02-03',9,6489),(20,29,2,'2019-01-04',6,7488),(7,49,7,'2019-01-08',5,4035),(7,49,27,'2019-01-25',9,7263),(40,23,12,'2019-02-05',10,4330),(36,2,50,'2019-01-13',3,2391),(31,38,38,'2019-02-22',6,2136),(50,24,11,'2019-03-19',1,1042),(9,21,31,'2019-01-13',3,2454),(34,34,35,'2019-01-29',6,7614),(28,39,19,'2014-07-04',1,1583),(28,31,38,'2017-01-27',7,2849),(40,27,3,'2019-02-25',5,3605),(28,31,34,'2018-08-28',4,1628),(31,12,18,'2018-02-18',3,3504),(44,27,30,'2019-03-14',6,4326),(47,35,33,'2019-01-26',4,2248),(18,47,24,'2019-02-28',1,1343),(23,7,27,'2019-01-20',5,8750),(44,15,46,'2019-02-23',4,4976),(2,1,22,'2019-02-21',1,483),(36,29,5,'2019-01-26',9,11232),(4,44,35,'2019-03-23',5,5835),(42,19,37,'2019-03-21',3,5658),(45,24,31,'2018-08-02',6,6252),(11,24,12,'2016-09-22',4,4168),(36,32,33,'2019-03-30',9,1089),(23,4,41,'2019-03-28',8,4128),(41,25,38,'2019-01-10',10,6090),(10,5,38,'2019-01-19',3,1719),(9,14,12,'2019-01-02',8,944),(1,5,16,'2019-02-09',4,2292),(18,26,34,'2019-03-14',3,2064),(1,37,32,'2016-07-09',2,2128),(40,3,49,'2009-11-25',4,6980),(24,22,9,'2019-02-27',8,6824),(42,24,48,'2017-09-22',8,8336),(32,6,17,'2019-01-21',9,7371),(37,19,4,'2019-02-25',2,3772),(50,13,14,'2015-02-13',3,420),(5,16,50,'2019-03-07',6,10026),(28,21,15,'2019-03-19',1,818),(36,33,33,'2014-02-21',6,11376),(29,21,48,'2019-01-02',8,6544),(29,10,16,'2019-01-07',3,4605),(12,45,14,'2019-03-03',6,11742),(27,30,18,'2019-03-29',1,1066),(33,1,8,'2019-01-25',8,3864),(35,1,40,'2019-01-12',5,2415),(11,12,18,'2019-07-18',4,4672),(32,5,25,'2019-01-31',9,5157),(2,44,29,'2019-02-12',10,11670),(14,25,7,'2019-01-09',10,6090),(39,41,32,'2019-03-09',3,5373),(45,7,36,'2019-02-15',6,10500),(23,22,32,'2019-01-20',2,1706),(3,26,34,'2019-01-09',6,4128),(42,4,26,'2019-03-18',10,5160),(48,33,34,'2010-10-11',7,13272),(19,30,45,'2019-03-21',1,1066),(31,41,27,'2019-02-10',1,1791),(31,23,39,'2019-01-28',9,3897),(26,41,43,'2019-03-03',5,8955),(14,1,37,'2019-02-09',2,966),(8,30,33,'2019-02-03',3,3198),(21,22,33,'2019-02-23',9,7677),(23,38,38,'2019-03-04',10,3560),(33,27,1,'2019-02-17',8,5768),(41,3,41,'2009-04-23',1,1745),(23,9,12,'2019-03-03',5,8690),(11,7,7,'2019-01-22',7,12250),(15,3,18,'2015-02-07',9,15705),(42,22,37,'2019-03-21',1,853),(22,34,5,'2019-03-17',2,2538),(25,29,17,'2019-03-22',4,4992),(1,17,5,'2019-02-19',3,1116),(18,18,11,'2019-02-23',1,929),(23,31,25,'2016-03-26',5,2035),(46,35,13,'2019-03-02',4,2248),(34,10,43,'2019-02-09',2,3070),(3,38,18,'2019-03-30',5,1780),(3,21,24,'2019-01-24',9,7362),(10,44,15,'2019-01-10',5,5835),(47,44,15,'2019-03-04',4,4668),(12,16,46,'2019-03-19',5,8355),(20,32,29,'2019-02-01',9,1089),(28,44,6,'2019-01-10',7,8169),(46,41,13,'2019-02-21',7,12537),(37,30,42,'2019-01-26',7,7462),(2,8,12,'2019-03-10',10,15590),(35,33,28,'2015-12-06',10,18960),(50,13,10,'2014-01-10',6,840),(50,18,44,'2019-01-03',5,4645),(25,38,49,'2019-02-08',4,1424),(17,24,48,'2017-05-27',9,9378),(6,27,44,'2019-03-10',3,2163),(12,15,21,'2019-03-11',6,7464)
GO

INSERT INTO Sales VALUES
	(6,17,8,'2019-01-01',8,2976),(14,15,44,'2019-01-28',4,4976),(13,16,40,'2019-01-23',5,8355),(28,5,21,'2019-01-22',5,2865),(22,46,12,'2015-08-27',10,2020),(46,14,31,'2019-02-01',2,236),(38,16,25,'2019-03-24',2,3342),(7,19,39,'2019-03-15',9,16974),(31,50,22,'2019-01-26',1,1043),(45,26,2,'2019-01-06',1,688),(17,25,48,'2019-01-12',5,3045),(8,46,43,'2008-07-21',7,1414),(32,36,43,'2019-01-27',8,11344),(11,50,26,'2019-01-26',1,1043),(33,46,24,'2014-05-25',1,202),(49,14,49,'2019-03-22',8,944),(17,44,19,'2019-03-15',8,9336),(12,7,25,'2019-01-28',5,8750),(39,8,17,'2019-03-22',3,4677),(3,49,26,'2019-01-31',1,807),(31,13,12,'2010-02-10',2,280),(31,13,6,'2008-12-07',4,560),(39,33,19,'2015-05-27',5,9480),(50,11,39,'2019-03-23',4,2664),(20,43,30,'2013-02-09',4,2132),(32,8,23,'2019-03-01',10,15590),(30,23,48,'2019-02-16',9,3897),(5,12,40,'2018-12-27',7,8176),(22,13,9,'2018-09-03',8,1120),(37,42,3,'2019-01-23',1,597),(10,20,16,'2019-02-06',7,3598),(33,23,21,'2019-02-15',2,866),(26,3,46,'2010-12-08',9,15705),(7,47,39,'2019-03-22',9,12087),(38,1,19,'2019-02-15',5,2415),(25,6,32,'2019-03-18',8,6552),(49,18,17,'2019-02-11',8,7432),(8,42,22,'2019-02-10',2,1194),(45,21,7,'2019-03-03',2,1636),(12,10,28,'2019-03-13',5,7675),(34,19,33,'2019-01-06',10,18860),(20,37,3,'2014-08-04',10,10640),(49,50,3,'2019-03-15',4,4172),(49,1,28,'2019-01-07',2,966),(32,48,13,'2019-01-22',5,3630),(25,38,9,'2019-03-05',10,3560),(29,30,14,'2019-01-30',7,7462),(5,12,3,'2013-09-16',9,10512),(9,27,30,'2019-01-20',4,2884),(44,11,2,'2019-03-14',5,3330),(13,30,19,'2019-02-03',10,10660),(18,45,25,'2019-03-30',3,5871),(50,44,33,'2019-03-20',8,9336),(12,43,5,'2017-01-02',9,4797),(22,6,23,'2019-03-13',2,1638),(23,33,10,'2017-04-29',5,9480),(23,29,35,'2019-01-17',9,11232),(18,33,11,'2017-07-13',8,15168),(16,50,32,'2019-02-26',7,7301),(10,39,39,'2011-08-21',1,1583),(32,50,33,'2019-03-24',5,5215),(28,27,50,'2019-01-04',1,721),(40,33,41,'2009-03-31',6,11376),(22,38,32,'2019-03-18',5,1780),(33,13,49,'2015-10-26',10,1400),(38,9,31,'2019-01-12',9,15642),(4,7,9,'2019-01-08',10,17500),(8,19,36,'2019-02-03',9,16974),(4,36,15,'2019-03-06',5,7090),(22,9,50,'2019-01-02',8,13904),(42,34,23,'2019-03-08',1,1269),(28,26,50,'2019-03-19',6,4128),(18,26,46,'2019-03-14',4,2752),(46,8,24,'2019-02-21',6,9354),(16,17,36,'2019-02-17',2,744),(13,38,10,'2019-01-22',2,712),(43,4,33,'2019-02-24',5,2580),(17,35,33,'2019-01-20',5,2810),(29,11,47,'2019-02-23',1,666),(7,33,17,'2018-02-25',7,13272),(19,41,7,'2019-02-25',1,1791),(12,45,44,'2019-02-18',8,15656),(9,21,19,'2019-03-15',6,4908),(5,7,46,'2019-02-09',4,7000),(27,18,16,'2019-01-11',9,8361),(48,20,20,'2019-01-20',9,4626),(3,27,12,'2019-02-04',2,1442),(25,43,2,'2011-03-06',4,2132),(17,35,2,'2019-02-07',10,5620),(42,22,8,'2019-02-11',2,1706),(31,23,2,'2019-02-11',7,3031),(11,14,20,'2019-01-15',8,944),(30,25,9,'2019-01-06',3,1827),(43,3,20,'2013-08-25',1,1745),(34,45,25,'2019-01-15',8,15656),(3,46,46,'2012-09-17',5,1010),(31,23,30,'2019-01-23',8,3464),(4,6,15,'2019-02-06',5,4095),(9,6,5,'2019-02-04',7,5733),(13,44,19,'2019-01-19',9,10503),(10,39,36,'2015-07-09',7,11081),(21,50,9,'2019-03-14',1,1043),(13,42,42,'2019-01-16',8,4776),(49,2,48,'2019-01-16',1,797),(30,11,31,'2019-03-20',10,6660),(17,25,39,'2019-02-08',1,609),(37,21,37,'2019-03-21',1,818),(16,30,3,'2019-01-07',6,6396),(35,35,16,'2019-01-12',10,5620),(18,19,44,'2019-03-26',2,3772),(37,1,16,'2019-03-11',3,1449),(41,48,39,'2019-03-02',9,6534),(37,36,47,'2019-03-24',1,1418),(16,11,9,'2019-02-18',9,5994),(8,36,23,'2019-02-14',8,11344),(3,16,48,'2019-03-29',6,10026),(7,46,39,'2008-03-12',9,1818),(15,10,38,'2019-02-27',4,6140),(6,47,16,'2019-02-18',3,4029),(1,34,48,'2019-02-01',4,5076),(15,36,32,'2019-02-27',8,11344),(24,35,41,'2019-02-02',4,2248),(6,40,38,'2019-03-22',5,5890),(22,26,28,'2019-03-05',10,6880),(43,40,24,'2019-01-21',5,5890),(27,16,46,'2019-02-07',6,10026),(8,39,14,'2011-01-19',5,7915),(14,10,14,'2019-02-19',1,1535),(37,34,35,'2019-03-26',10,12690),(18,37,40,'2019-02-13',10,10640),(31,23,11,'2019-03-09',7,3031),(11,44,30,'2019-03-20',8,9336),(3,47,19,'2019-01-17',6,8058),(47,49,10,'2019-02-11',8,6456),(13,21,19,'2019-03-25',8,6544),(42,25,49,'2019-02-01',4,2436),(50,1,28,'2019-03-10',7,3381),(45,8,7,'2019-01-23',7,10913),(31,42,16,'2019-01-04',10,5970),(36,46,24,'2014-07-02',10,2020),(33,32,23,'2019-02-06',3,363),(11,6,38,'2019-03-11',6,4914),(28,16,9,'2019-01-22',3,5013),(16,36,6,'2019-03-12',10,14180),(47,40,48,'2019-03-27',5,5890),(21,41,13,'2019-01-09',10,17910),(4,16,31,'2019-01-02',5,8355),(18,50,35,'2019-02-20',10,10430),(7,40,20,'2019-01-27',4,4712),(43,13,29,'2009-10-22',9,1260),(12,22,2,'2019-03-12',10,8530),(9,29,30,'2019-03-17',7,8736),(42,15,24,'2019-02-06',4,4976),(27,3,50,'2014-02-24',7,12215),(6,37,3,'2013-01-28',4,4256),(46,43,6,'2017-07-24',2,1066),(38,41,15,'2019-02-01',5,8955),(5,1,48,'2019-03-23',1,483),(32,13,12,'2018-05-20',2,280),(33,28,34,'2008-01-17',5,4375),(24,35,25,'2019-03-06',6,3372),(22,42,27,'2019-02-16',6,3582),(1,2,24,'2019-03-25',9,7173),(16,5,40,'2019-03-01',3,1719),(3,19,34,'2019-02-13',5,9430),(39,19,8,'2019-01-14',8,15088),(10,4,18,'2019-03-14',10,5160),(35,18,2,'2019-03-23',1,929),(47,33,7,'2013-05-17',7,13272),(22,49,13,'2019-02-27',6,4842),(50,25,38,'2019-01-27',8,4872),(17,20,47,'2019-02-11',5,2570),(23,18,34,'2019-02-08',4,3716),(18,22,23,'2019-01-25',1,853),(5,2,11,'2019-02-09',7,5579),(29,12,45,'2017-10-05',1,1168),(18,2,35,'2019-01-23',4,3188),(23,6,30,'2019-02-12',2,1638),(13,34,12,'2019-01-26',7,8883),(41,15,42,'2019-01-23',5,6220),(36,48,15,'2019-03-04',10,7260),(5,43,1,'2018-12-24',2,1066),(1,17,12,'2019-02-17',4,1488),(49,46,22,'2017-07-15',4,808),(6,48,50,'2019-01-19',10,7260),(1,32,10,'2019-02-04',7,847),(46,38,6,'2019-03-26',7,2492),(19,30,40,'2019-02-18',7,7462),(21,13,41,'2016-07-19',3,420),(1,33,50,'2017-06-25',4,7584),(36,50,37,'2019-01-30',8,8344),(46,38,29,'2019-03-18',8,2848),(15,33,45,'2019-02-20',1,1896),(45,23,10,'2019-02-23',9,3897),(23,29,25,'2019-01-07',4,4992),(2,22,34,'2019-03-12',10,8530),(13,17,22,'2019-02-15',7,2604),(43,47,30,'2019-02-10',7,9401),(19,46,29,'2013-12-21',2,404),(38
最低0.47元/天 解锁文章
Fergus awsl
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
LeetCode sql题解 6 (按照面试出现频率)
weixin_44266342的博客
11-26 540
1082. 销售分析 I 产品表：Product Column Name Type product_id int product_name varchar unit_price int product_id 是这个表的主键. 销售表：Sales Column Name Type seller_id int product_id int buyer...
SQL语句练习实例之四——找出促销活动中销售额最高的职员
weixin_33779515的博客
10-09 388
---找出促销活动中销售额最高的职员---你刚在一家服装销售公司中找到了一份工作，此时经理要求你根据数据库中的两张表得到促销活动销售额最高的销售员---1.一张是促销活动表---2.一张是销售客列表create table Promotions(activity nvarchar(30),sdate datetime,edate datetime)insert Promotionsselect '...
LeetCode-1082. 销售分析 I (简单)
Hello_JavaScript的博客
02-20 641
产品表：Product +--------------+---------+ | Column Name | Type | +--------------+---------+ | product_id | int | | product_name | varchar | | unit_price | int | +--------------+---------...
sql基础练习45题(包括思路与代码)
最新发布
改变从现在开始
03-19 986
sql基础练习45题(包括思路与代码)
SQL谁才是金牌销售员？（窗口函数排名、substr）
前景
08-10 479
SQL谁才是金牌销售员？（窗口函数排名、substr）
sqlserver训练
weixin_50864132的博客
03-30 941
原文首发于简书于[2018.07.30] 网上有一篇关于SQL的经典文章，超经典SQL练习题，做完这些你的SQL就过关了，引用和分析它的人很多，于是今天复习SQL的时候找来练了练手。原作者用的是Mysql ，我在这里用的是SQLServer（二者语法差别不大）。 题目顺序和原文一致，但是我没有把所有题目都解一遍，因为很多题目是重复的。在每道题题目下我除了放SQL语句外，还把SQLServer的运行输出结果放了上来，展示效果更直观一些。另外，因为数据量非常小，所以就没考虑SQL语句的性能优化，只求顺利完成题目
MySQL练习题
HD0do的博客
03-28 3632
MySQL练习题 文档下载链接： 链接：https://pan.baidu.com/s/1K9hoIbwWCNmEcaTBYBupMg 提取码：bs3g 1. 组合两个表 需求：编写一个 SQL 查询，对两表进行关联，展示列为： FirstName, LastName, City, State 展示效果： FirstName LastName City State Allen Wang New York City New York Create table If Not Exists 1
LeetCode-SQL（三）
Sdhrs_nn的博客
10-31 518
以下题目均来自leetcode 41、618.学生地理信息报告 难度：★★★★★ 一所美国大学有来自亚洲、欧洲和美洲的学生，他们的地理信息存放在如下 student 表中。 | name | continent | |--------|-----------| | Jack | America | | Pascal | Europe | | Xi | Asia | | Jane | America | 写一个查询语句实现对大洲（continent）列的 透视.
SQL-案例：销售金额总和最大的=销售
dameijiangshan的博客
04-29 702
编写一个 SQL 查询，查询总销售额最高的销售者，如果有并列的，就都展示出来，以任意顺序返回结果表。可修改数值：进行验算。
leetcode1082. 销售分析 I （SQL）
hebtu666
02-22 4493
产品表：Product +--------------+---------+ | Column Name | Type | +--------------+---------+ | product_id | int | | product_name | varchar | | unit_price | int | +--------------+---------...
2021-05-10
小蚂蚁的博客
05-10 163
销售分析 需求一：编写一个 SQL 查询，查询总销售额最高的销售者，如果有并列的，就都展示出来。 展示效果： seller_id 1 3 Create table If Not Exists 45_Product (product_id int, product_name varchar(10), unit_price int); Create table If Not Exists 45_Sales (seller_id int, product_id int,buyer_id i
SQLSERVER查询练习习题.doc
12-02
SQLSERVER查询练习习题.doc
sqlserver子查询练习.sql
08-16
Microsoft SQL Server 2008技术内幕：T-SQL语言基础（子查询）练习sql文件
SQL SERVER 查询语句练习
10-27
一些基本的T-sql查询联系，包涵答案，多表查询之类
LeetCode的SQL题练手（MySQL实现）
仰起脸笑得像满月
09-15 1883
Contens175 组合两个表官方解法备注181 超过经理收入的员工我的解法182 查找重复的电子邮箱我的解法解法二183 从不订购的客户我的解法官方解法197 上升的温度我的错误题解正确题解569 超过5名学生的课我的错误解法正确解法力扣精选70题1068 产品销售分析 I解法1303 求团队人数解法1069 产品销售分析II解法613 直线上的最近距离解法1251 平均售价解法584 寻找用户推荐人解法1173 即时食物配送 I解法LeetCode官方给出的另外两种解法1082 销售分析 I解法105
【SqlServer题目练习】
望仔的博客
09-17 484
【DDL&DML】【SqlServer题目练习】
SQL Server 常用查询练习
CSDN
07-04 5359
SQL Server（SQL Server数据库管理系统）是由Microsoft开发的关系型数据库管理系统（RDBMS），用于管理和存储大规模的数据。它是一种强大的数据库平台，广泛用于企业和组织中，以支持数据存储、管理、查询和分析。查询语句是用于与关系型数据库进行交互的命令或语句。它们允许您执行各种操作，包括检索数据、插入、更新和删除数据，以及创建、修改和删除数据库表和其他数据库对象。
sqlserver- 查询练习
Fergus的博客
10-03 331
1.Department Highest Salary; 2.拓展EXISTS
LeetCode sql每日刷题 4 (按照出现频率)
weixin_44266342的博客
11-20 400
601. 体育馆的人流量 X 市建了一个新的体育馆，每日人流量信息被记录在这三列信息中：序号 (id)、日期 (visit_date)、 人流量 (people)。 请编写一个查询语句，找出人流量的高峰期。高峰期时，至少连续三行记录中的人流量不少于100。 例如，表 stadium： id visit_date people 1 2017-01-01 10 2 2017-01-...
sql server练习
08-19
SQL Server练习是通过练习题目来帮助学习和掌握SQL Server数据库的基础知识和技能。为了进行练习，需要先准备好SQL Server数据库，并创建相应的练习题目数据库。可以从官方网站下载并安装适合的SQL Server版本，比如...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值