【多选题】在企业电子商务的安全认证中,信息认证主要用于()。
【单选题】假设sales表用于存储销售信息,sname列为销售人员姓名,smoney列为销售额度,现在要查询每个销售人员的销售次数,销售总金额,则下列()查询语句的执行结果能够得到这些信息。
A.
select sname,sum(smoney),count(sname) from sales group by sname
B.
select sname,sum(smoney) from sales
C.
select sname,sum(smoney) from sales group by sname order by sname
D.
select sum(smoney) from sales group by sname order by sname
【单选题】对于一个垄断厂商来说,其供给曲线( )。
【单选题】假设ABC表用于存储销售信息,A 列为销售人员名,C列为销售额度,现在需要查询每个销售人员的销售次数、销售总金额,则正确的查询语句是( )
A.
select A , sum(C) ,count(A) from ABC group by A
B.
select A,sum(C) from ABC
C.
select A,sum(C) from ABC group by A order by A
D.
select sum(C) from ABC group by a order by A
【单选题】假设sales表用于存储销售信息,sname列为销售人员姓名,smoney列为销售额。现在需要查询最大一笔销售额是多少,则正确的查询语句是( )
A.
select max(smoney) from sales where max(smoney)>0
B.
select sname,max(smoney) from sales where count(sname)>0
C.
select sname,max(smoney) from sales group by sname,smoney
D.
select max(smoney) from sales
【单选题】假设sales表用于存储销售信息,sname列为销售人员姓名,smoney列为销售额度,现在需要查询最大一笔销售额度是多少,则正确的查询语句是()
A.
select max(smoney) from sales where max(smoney)>0
B.
select sname,max(smoney) from sales where count(sname)>0
C.
select sname,max(smoney) from sales order by sname,smoney
D.
select max(smoney) from sales
【单选题】假设sales表用于存储销售信息,sname列为销售人员姓名,smoney列为销售额,现在要查询每个销售人员的销售次数、销售总金额,则下列( )查询语句的执行结果能得到这些信息。
A.
select sname,sum(smoney),count(sname) from sales group by sname
B.
select sname,sum(smoney) from sales
C.
select sname,sum(smoney) from sales group by sname order by sname
D.
select sum(smoney) from sales group by sname order by sname
【单选题】假设Sales表用于存储销售信息,SName列为销售人员姓名,SMoney列为销售额度,现在要查询每个销售人员的销售次数、销售总金额,则下列()查询语句的执行结果能得到这些信息。
A.
SELECT SName, SUM(SMoney), COUNT(SName) FROM Sales GROUP BY SName
B.
SELECT SName, SUM(SMoney) FROM Sales
C.
SELECT SName, SUM(SMoney) FROM Sales GROUP BY SName ORDER BY SName
D.
SELECT SUM(SMoney) FROM Sales GROUP BY SName ORDER BY SName
【单选题】假设ABC表用于存储销售信息,A 列为销售人员名,C列为销售额度,现在需要查询最大一笔销售额度是多少,则正确的查询语句是( )
A.
select max(C) from ABC where max(C)>0
B.
select A, max (C)from ABC where count(A)>0
C.
select A,max (C) from ABC group by A,C
D.
select max (C) from ABC
【判断题】在所有会计凭证上只需会计部门的相关人员签字盖章,对经济业务的合法性、真实性和正确性负完全责任。