creat view Salaries2 (emp_name,sal_date,sal_amt)
as select s0.emp_name,so.sal_date,max(s0.sal_amt)
from Salaries as s0,Salaries as s1
where s0.sal_date<=s1.date
and s0.emp=s1.emp_date
group by s0.emp_name,s0.sal_date
having count(*)<=2彻底糊涂中……………………
as select s0.emp_name,so.sal_date,max(s0.sal_amt)
from Salaries as s0,Salaries as s1
where s0.sal_date<=s1.date
and s0.emp=s1.emp_date
group by s0.emp_name,s0.sal_date
having count(*)<=2彻底糊涂中……………………
解决方案 »
- 新手求救
- 急求解决 mysqli::real_connect(): (HY000/2003): Can't connect to MySQL server on '10.
- 求,mysql里有类似mssql里的sp_makewebtask吗?
- 多表查询
- 这是哪里错了
- 关于MySQL Merge引擎的疑问?
- 如何删除一有外键的列
- ######## 求1SQL语句 在线等
- Mysql load data infile 变量使用问题?
- 哪位大神有Navicat for mysql 11.0.10注册码
- MYSQL的字段完全书写格式问题,假设库为TEST 表名为ADMIN 语句可以写成select % from test.admin 如果再进一步要导出字段中的数据,假设字段有一个NAME,是写成像name.test.admin test.admin.na
- MySQL创建表时候出现1300错误
as select s0.emp_name,s0.sal_date,max(s0.sal_amt)
from Salaries as s0,Salaries as s1
where s0.sal_date <=s1.date
and s0.emp=s1.emp_date
group by s0.emp_name,s0.sal_date
having count(*) <=2
as select s0.emp_name,s0.sal_date,max(s0.sal_amt)
from Salaries as s0,Salaries as s1
where s0.sal_date <=s1.date
and s0.emp=s1.emp_date
group by s0.emp_name,s0.sal_date
having count(*) <=2
[/align]
creat view Salaries2 (emp_name,sal_date,sal_amt)
as select s0.emp_name,s0.sal_date,max(s0.sal_amt)
from Salaries as s0,Salaries as s1
where s0.sal_date <=s1.date
and s0.emp_date=s1.emp_date
group by s0.emp_name,s0.sal_date
having count(*) <=2
create table Salaries
(
emp_name char(10) not null,
sal_date date not null,
sal_amt decimal(8,2) not null,
primary key (emp_name,sal_date)
);insert Salaries
values
('Tom' '1996-06-20',500.00 ),
('Tom' '1996-08-20',700.00 ),
('Tom' '1996-10-20',800.00 ),
('Tom' '1996-12-20',900.00 ),
('Dick' '1996-06-20',500.00 ),
('Harry' '1996-07-20',500.00 ),
('Harry' '1996-09-20',700.00 ),
create view Salaries2 (emp_name,sal_date,sal_amt)
as select s0.emp_name,s0.sal_date,max(s0.sal_amt)
from Salaries as s0,Salaries as s1
where s0.sal_date <=s1.sal_date
and s0.sal_date=s1.sal_date
group by s0.emp_name,s0.sal_date
having count(*) <=2 ;原表内容
Query SELECT * FROM salaries s, Sun May 04 11:35:54 2008
Tom 1996-06-20 500.00
Tom 1996-08-20 700.00
Tom 1996-10-20 800.00
Tom 1996-12-20 900.00
Dick 1996-06-20 500.00
Harry 1996-07-20 500.00
Harry 1996-09-20 700.00 视图内容
Query SELECT * FROM salaries2 s, Sun May 04 11:36:27 2008
Dick 1996-06-20 500.00
Harry 1996-07-20 500.00
Harry 1996-09-20 700.00
Tom 1996-06-20 500.00
Tom 1996-08-20 700.00
Tom 1996-10-20 800.00
Tom 1996-12-20 900.00