没有合适的资源?快使用搜索试试~ 我知道了~
SQL Server面试常用sql整理
需积分: 0 2 下载量 79 浏览量
2023-08-30
17:23:58
上传
评论
收藏 312KB PDF 举报
温馨提示
试读
13页
SQL Server面试常用sql整理
资源推荐
资源详情
资源评论
面试常用 SQL 整理
我们都知道面试的时候通常都会考数据库部分的知识,所以在此整理了下我们
常用的面试中常用的一些查询语句 SQL,本人测试数据库为 SQL Server2008
首先在数据库中建立一个测试库,此处用 DavidTest 代替
数据表与相应测试数据
USE [DavidTest]
GO
/****** Object: Table [dbo].[Teacher] Script Date: 02/19/2013
01:09:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Teacher](
[TId] [varchar](10) NULL,
[Tname] [nvarchar](10) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Teacher] ([TId], [Tname]) VALUES (N'01', N'张三')
INSERT [dbo].[Teacher] ([TId], [Tname]) VALUES (N'02', N'李四')
INSERT [dbo].[Teacher] ([TId], [Tname]) VALUES (N'03', N'王五')
/****** Object: Table [dbo].[Student] Script Date: 02/19/2013
01:09:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Student](
[SId] [varchar](10) NULL,
[Sname] [nvarchar](10) NULL,
[Sage] [datetime] NULL,
[Ssex] [nvarchar](10) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Student] ([SId], [Sname], [Sage], [Ssex]) VALUES
(N'01', N'赵雷', CAST(0x0000806800000000 AS DateTime), N'男')
INSERT [dbo].[Student] ([SId], [Sname], [Sage], [Ssex]) VALUES
(N'02', N'钱电', CAST(0x000081CA00000000 AS DateTime), N'男')
INSERT [dbo].[Student] ([SId], [Sname], [Sage], [Ssex]) VALUES
(N'03', N'孙风', CAST(0x000080F300000000 AS DateTime), N'男')
INSERT [dbo].[Student] ([SId], [Sname], [Sage], [Ssex]) VALUES
(N'04', N'李云', CAST(0x0000814100000000 AS DateTime), N'男')
INSERT [dbo].[Student] ([SId], [Sname], [Sage], [Ssex]) VALUES
(N'05', N'周梅', CAST(0x0000832300000000 AS DateTime), N'女')
INSERT [dbo].[Student] ([SId], [Sname], [Sage], [Ssex]) VALUES
(N'06', N'吴兰', CAST(0x0000837E00000000 AS DateTime), N'女')
INSERT [dbo].[Student] ([SId], [Sname], [Sage], [Ssex]) VALUES
(N'07', N'郑竹', CAST(0x00007FB000000000 AS DateTime), N'女')
INSERT [dbo].[Student] ([SId], [Sname], [Sage], [Ssex]) VALUES
(N'08', N'王菊', CAST(0x0000807B00000000 AS DateTime), N'女')
/****** Object: Table [dbo].[SC] Script Date: 02/19/2013 01:09:01
******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SC](
[SId] [varchar](10) NULL,
[CId] [varchar](10) NULL,
[score] [decimal](18, 1) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[SC] ([SId], [CId], [score]) VALUES (N'01', N'01',
CAST(59.0 AS Decimal(18, 1)))
INSERT [dbo].[SC] ([SId], [CId], [score]) VALUES (N'01', N'02',
CAST(89.0 AS Decimal(18, 1)))
INSERT [dbo].[SC] ([SId], [CId], [score]) VALUES (N'01', N'03',
CAST(99.0 AS Decimal(18, 1)))
INSERT [dbo].[SC] ([SId], [CId], [score]) VALUES (N'02', N'01',
CAST(70.0 AS Decimal(18, 1)))
INSERT [dbo].[SC] ([SId], [CId], [score]) VALUES (N'02', N'02',
CAST(60.0 AS Decimal(18, 1)))
INSERT [dbo].[SC] ([SId], [CId], [score]) VALUES (N'02', N'03',
CAST(80.0 AS Decimal(18, 1)))
INSERT [dbo].[SC] ([SId], [CId], [score]) VALUES (N'03', N'01',
CAST(80.0 AS Decimal(18, 1)))
INSERT [dbo].[SC] ([SId], [CId], [score]) VALUES (N'03', N'02',
CAST(80.0 AS Decimal(18, 1)))
INSERT [dbo].[SC] ([SId], [CId], [score]) VALUES (N'03', N'03',
CAST(80.0 AS Decimal(18, 1)))
INSERT [dbo].[SC] ([SId], [CId], [score]) VALUES (N'04', N'01',
CAST(50.0 AS Decimal(18, 1)))
INSERT [dbo].[SC] ([SId], [CId], [score]) VALUES (N'04', N'02',
CAST(30.0 AS Decimal(18, 1)))
INSERT [dbo].[SC] ([SId], [CId], [score]) VALUES (N'04', N'03',
CAST(20.0 AS Decimal(18, 1)))
INSERT [dbo].[SC] ([SId], [CId], [score]) VALUES (N'05', N'01',
CAST(76.0 AS Decimal(18, 1)))
INSERT [dbo].[SC] ([SId], [CId], [score]) VALUES (N'05', N'02',
CAST(87.0 AS Decimal(18, 1)))
INSERT [dbo].[SC] ([SId], [CId], [score]) VALUES (N'06', N'01',
CAST(31.0 AS Decimal(18, 1)))
INSERT [dbo].[SC] ([SId], [CId], [score]) VALUES (N'06', N'03',
CAST(34.0 AS Decimal(18, 1)))
INSERT [dbo].[SC] ([SId], [CId], [score]) VALUES (N'07', N'02',
CAST(89.0 AS Decimal(18, 1)))
INSERT [dbo].[SC] ([SId], [CId], [score]) VALUES (N'07', N'03',
CAST(98.0 AS Decimal(18, 1)))
/****** Object: Table [dbo].[Course] Script Date: 02/19/2013
01:09:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Course](
[CId] [varchar](10) NULL,
[Cname] [nvarchar](10) NULL,
[TId] [varchar](10) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Course] ([CId], [Cname], [TId]) VALUES (N'01', N'语文',
N'02')
剩余12页未读,继续阅读
资源评论
dber_ablewang
- 粉丝: 0
- 资源: 8
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功