大学SQL数据库原理大题求好心人帮答下谢谢

Question

如题所述

Answer 1

1：select * from employees;

2：select * from employees t where t.employeeName like 'Back%';
3：select * from employees t where t.employeeName like 'P%' and t.daysOfHoliday < 3;
4：select * from employees t where t.workyears>5 or t.daysOfHoliday < 5;
5：select * from employees t where t.employeeName not like 'B%';

好好学习，不会的话，我可以教你，我以前也是屌丝，现在我什么都会了 。。追问

那能帮我看看其他题目怎么做么？

这两道大题怎么做vb的

追答

准备补考吧

Answer 2

(1)select * from employees;
(2)select * from employees where employeeName regexp '^Back';
(3)select * from employees where employeeNmae regexp '^P' and daysOfHoliday <=3;
(4)select * from employees where workyears >=5 or daysOfHoliday<5;
(5)select * from employees where employeeName regexp '^[^B]';
# 个人的理解,希望可以帮到你

Answer 3

1:
select * from employees
2:
select * from employees where employeeName like 'Back%'
3:
select * from employees Where employeeName like 'P%' and daysOfHoliday < 3
4:
select * from employees Where workyears > 5 or daysOfHoliday < 5
5:
select * from employees where employeeName not like 'B%'

Answer 4

select * from Employees
select * from Employees where EmployeeName like 'Back%'
select * from Employees where EmployeeName like 'P%' and daysOfHoliday<3
select * from Employees where WorkYears>=5 or daysOfHoliday<5
select * from Employees where EmployeeName not like 'B%'