UC知道请写出SQLscript：(急求答案，非常感谢)
来源：百度知道 编辑：UC知道 时间：2024/06/18 17:20:05
两个表结构如下，请写出SQLscript：
1、列出表1中所有的username和passwd
2、列出购买了printer的人
3、以department，username属性对表1排序
Username Passwd Department Birthdate userid
abc Abc123 RD 1972-01-01 1
ccc Ccc123 RD 1981-01-01 2
bbb Bbb123 IT 1973-01-01 3
ade Ade123 IT 1966-02-21 4
Table1:userinfo
Table2: orderinfo
Userid Orderid product
3 1 printer
2 2 book
1、列出表1中所有的username和passwd
2、列出购买了printer的人
3、以department，username属性对表1排序
Username Passwd Department Birthdate userid
abc Abc123 RD 1972-01-01 1
ccc Ccc123 RD 1981-01-01 2
bbb Bbb123 IT 1973-01-01 3
ade Ade123 IT 1966-02-21 4
Table1:userinfo
Table2: orderinfo
Userid Orderid product
3 1 printer
2 2 book
如果你这是三个SQL 就是下面：
1.select u.username,u.passwd from userinfo u
2. select u.username,o.product from userinfo u join orderinfo o on u.userid=o.userid where o.product='printer'
3. select u.username,u.passwd,u.department,u.birthdate,u.userid from userinfo order by u.department, u.username
如果这三个是一个SQL 是下面：
select u.username,u.passwd,u.department,u.birthdate,u.userid from userinfo u join orderinfo o on u.userid=o.userid where o.product='printer'
order by u.department, u.username
1,select username,passwd from userinfo
2,select userid,username from userinfo u,orderinfo o
where product='printer' and u.userid=o.userid
3,select * from uesrinfo
order by department，username