帮我解释一下这条sql语句的意思select month01.pk_deptdoc as dept,month01.amot as month01,month02.amot as month02from(select h.pk_deptdoc,sum(expense_amot) as amot from te_expense_b b left join te_expense h on b.pk_expense=h.pk_expensewhere

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/01 01:51:35
帮我解释一下这条sql语句的意思select month01.pk_deptdoc as dept,month01.amot as month01,month02.amot as month02from(select h.pk_deptdoc,sum(expense_amot) as amot from te_expense_b b left join te_expense h on b.pk_expense=h.pk_expensewhere

帮我解释一下这条sql语句的意思select month01.pk_deptdoc as dept,month01.amot as month01,month02.amot as month02from(select h.pk_deptdoc,sum(expense_amot) as amot from te_expense_b b left join te_expense h on b.pk_expense=h.pk_expensewhere
帮我解释一下这条sql语句的意思
select month01.pk_deptdoc as dept,month01.amot as month01,month02.amot as month02
from
(select h.pk_deptdoc,sum(expense_amot) as amot from te_expense_b b left join te_expense h on b.pk_expense=h.pk_expense
where h.dbilldate>='2013-01-01' and h.dbilldate='2013-02-01' and h.dbilldate

帮我解释一下这条sql语句的意思select month01.pk_deptdoc as dept,month01.amot as month01,month02.amot as month02from(select h.pk_deptdoc,sum(expense_amot) as amot from te_expense_b b left join te_expense h on b.pk_expense=h.pk_expensewhere
这个语句就是一个查询里面嵌套查询的语句,month01,month02作为子查先查询出结果再进行连接进行查询.

帮我解释一下这条sql语句的意思select month01.pk_deptdoc as dept,month01.amot as month01,month02.amot as month02from(select h.pk_deptdoc,sum(expense_amot) as amot from te_expense_b b left join te_expense h on b.pk_expense=h.pk_expensewhere drop table if exists address_book;这句SQL语句是什么意思我备份的SQL语句中有这么一行, 大神帮我解释一下后面带问号的语句 Private Sub Worksheet_Change(ByVal Target As Range)帮我解释一下,下面每一句的意思Private Sub Worksheet_Change(ByVal Target As Range)Application.EnableEvents = FalseIf Target.Column = 5 And Target.Row < 7 Then Cells(Target.Row + 1,1).Sele 帮我解释一下这段英文的意思. 请帮我解释一下成语“美人迟暮”的意思?这是什么 帮我解释一下这幅图的意思, 帮我解释一下“寂寞”这个词的意思 谁帮我解释一下“洛阳纸贵”的意思? 帮我解释一下藤萝的意思 请帮我解释一下这条公式的意思!A2=IF(COUNTIF(模板!A:A,A2),VLOOKUP(A2,模板!A:B,2,0),) 求达人 帮解释一下下面句子的用法,特别是问号的意思 $sql_mobile=$mobile?'OR email_mobile=?' :' ';$sql='SELECT * from dtb_customer WHERE (email=?' .$sql_mobile.')'; 这条sql语句是什么意思CONSTRAINT fk_join_uid FOREIGN KEY (join_uid) REFERENCES users (u_id),//FOREIGN KEY (join_uid):代表当前表的字段//users (u_id)代表另一张表的字段那么users是主表.join_uid是从表,对么?我知道这 select ename from emp where ename like'%A___'; 这条SQL语句中'%A___'是什么意思? sql如何取交集有这样两条sql语句select distinct id from a where id='123'select distinct id from a where id='456'我希望能把他们取得他们记录的交集,sql语句该如何写?错了 应该是这样的select distinct temid from a whe 我不明白,掠过的意思,请帮我解释一下好吗? 我要用SQL语句,想要查询的是fatype_code这个字段里面填写的是4位数的,数据.条件请问怎么写.菜鸟我是,我还是不是很懂,我的意思是我要从fa_type这张表里面搜索fatype_code是4位数的数据.这个SQL语 谁帮我解释一下下面这个图的意思,