--创建数据库
CREATE DATABASE Test002
--移动到Test002数据库
use Test002
--创建Sutdent表
create table Student1(
ID INT primary key,
Name nchar(10),
Scorse int,
Greder nchar(10)
)
--插入几条数据
--insert into Student(name,Scrose,Greder) values('张三','90','Java开发')
--insert into Student(name,Scrose,Greder) values('张三','90','Java开发')
--insert into Student(name,Scrose,Greder) values('张三','90','Java开发')
--insert into Student(name,Scrose,Greder) values('张三','90','Java开发')
--insert into Student(name,Scrose,Greder) values('李四','88','Html开发')
--insert into Student(name,Scrose,Greder) values('王五','92','Java开发')
--insert into Student(name,Scrose,Greder) values('赵六','80','Java开发')
--使用distint 去重 三个字段同时去重,不能根据某个字段去重返回所有结果集
SELECT distinct Greder,Name,Scrose FROM Student
--使用exists 根据某个字段去重 返回所有结果
select * from Student as A where NOT exists(select 1 from Student as B where A.Name = B.Name and A.ID > B.ID)
--复制Student表和里面的数据 插入到新表 StudentNew中
select * into StudentNew FROM Student