常用sql语句 语法

--select * from Orders where Id_P<>3

--select distinct ID_P from Orders order by id_p desc

--insert into Orders(Id_O,OrderNo,Id_P) values (6,1500,3)

--update Orders set OrderNo=800 where Id_O=6

--select * from Persons where LastName like '_d%' and FirstName Like '[jok]%'

--select p.Id_P as Id,p.LastName as LName,p.FirstName as FName from Persons as p

--select * from Persons as p inner join Orders as o on p.Id_P=o.Id_P

--select * from Persons as p Left Join Orders as o on p.Id_P=o.Id_P

--select * from Persons as p right join Orders as o on p.Id_P = o.Id_P

--select * from persons as p full join orders as o on p.Id_P = o.Id_P

--select Id_P  from Persons union select OrderNo  from Orders

--select Id_P,avg(OrderNo) as '【平均值】',sum(OrderNo) as '【总和】' from orders group by Id_P

--select  UPper(LastName),len(LastName) as length,format(GETDATE(),'yyyy-MM-dd') from Persons

--select left(LastName,3) from Persons