Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1029257
  • 博文数量: 239
  • 博客积分: 10
  • 博客等级: 民兵
  • 技术积分: 3618
  • 用 户 组: 普通用户
  • 注册时间: 2012-11-12 13:17
文章分类

全部博文(239)

文章存档

2021年(1)

2016年(1)

2015年(30)

2014年(91)

2013年(116)

分类: Oracle

2015-06-20 14:29:45

14.  Using  the  CUSTOMERS  table,   you  need  to  generate  a  report  that  shows  50%  of  each   credit 
amount in each income level. The report should NOT show any repeated credit amounts in each income 
level. 
Which   query would give the required result? 
A. SELECT   cust_income_level, DISTINCT cust_credit_limit * 0.50    
AS "50% Credit Limit" 
FROM customers; 
B. SELECT DISTINCT cust_income_level, DISTINCT cust_credit_limit * 0.50    
AS "50% Credit Limit" 
FROM customers; 
C. SELECT DISTINCT cust_income_level   '   '   cust_credit_limit * 0.50 AS "50% Credit Limit" 
FROM customers; 
D. SELECT cust_income_level ' ' cust_credit_limit * 0.50 AS "50% Credit Limit" 
FROM customers; 
Answer: C
1.DISTINCT只能出现在SQL的开头。
2.每个SQL语句只能有一个DISTINCT关键字。

阅读(1010) | 评论(0) | 转发(0) |
0

上一篇:Linux开机自启动weblogic

下一篇:1Z0-051-15题

给主人留下些什么吧!~~