{{sellerTotalView > 1 ? __("sellers", {number: sellerTotalView}) : __("seller", {number: sellerTotalView}) }}, {{numTotalView > 1 ? __("items", {number: numTotalView}) : __("item", {number: numTotalView}) }}
free FREE

Change Your Zip Code

Inventory information and delivery speeds may vary for different locations.

Location History

{{email ? __('Got it!') : __('Restock Alert')}}

We will notify you by email when the item back in stock.

Cancel
Yami

Jingdong book

Excel疑难千寻千解丛书:Excel 2010 SQL完全应用(附光盘)

{{buttonTypePin == 3 ? __("Scan to view more PinGo") : __("Scan to start")}}

Excel疑难千寻千解丛书:Excel 2010 SQL完全应用(附光盘)

{{__(":people-members", {'people': item.limit_people_count})}} {{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ item.invalid_price }} {{ itemDiscount }}
Ends in
{{ itemCurrency }}{{ item.valid_price }}
{{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }}
{{ itemDiscount }}
{{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }} {{ itemCurrency }}{{ item.invalid_price }} {{itemDiscount}}
{{ itemCurrency }}{{ item.valid_price }}
Sale ends in
Sale will starts after Sale ends in
{{ getSeckillDesc(item.seckill_data) }}
{{ __( "Pay with Gift Card to get sale price: :itemCurrency:price", { 'itemCurrency' : itemCurrency, 'price' : (item.giftcard_price ? priceFormat(item.giftcard_price) : '0.00') } ) }} ({{ itemCurrency }}{{ priceFormat(item.giftcard_price / item.bundle_specification) }}/{{ item.unit }}) Details
Best before

Currently unavailable.

We don't know when or if this item will be back in stock.

Unavailable in your area.
Sold Out

Details

Full product details
Editer Recommend

ExcelTip.net出品
微软全球最有价值专家力作
壁立千寻敢攀登,寻根究底解疑难

海报:

Content Description

《Excel疑难千寻千解丛书:Excel 2010 SQL完全应用(附CD光盘1张)》由林盘生、李懿、陈树青、黄朝阳编著,是 “Excel疑难千寻千解”丛书之一,为读者展示了在Excel 2010中运用SQL语句解决疑难问题的实战技巧。《Excel疑难千寻千解丛书:Excel 2010 SQL完全应用(附CD光盘1张)》包含SQL基础入门、运算符、常用函数、日期、排序、聚合函数、连接查询、子查询、SQL与数据透视表、SQL与VBA 等方面的应用技巧,以及SQL语句的综合应用。
《Excel疑难千寻千解丛书:Excel 2010 SQL完全应用(附CD光盘1张)》非常全面地阐述了SQL语言在Excel中的应用,SQL语法介绍具体全面,案例贴近实际,讲解深入透彻,帮助读者更加深入了解SQL语言,同时也揭开了SQL语言在Excel中使用的神秘面纱。

Catalogue

第1章 SQL基础入
1.1 熟悉Excel的SQL语言编写环境
疑难1 如何获取外部源数据
※ 通过OLE DB 接口获取外部数据源
※ 使用Microsoft Query导入外部源数据
疑难2 如何刷新导入的外部数据
※ 刷新导入的外部数据源
疑难3 在数据源移动后如何修改数据源的连接路径
※ 根据弹出提示自动修改移动的文件路径
※ 通过修改连接字符串来修改移动的文件路径
疑难4 如何将混合类型的字段强制设置为文本字段
※ 强制设置导入的外部数据源的字段为文本形式
※ SQL中的连接字符串详解
疑难5 如何对外部数据进行安全设置
※ 安全设置外部数据
1.2 SQL基础概念
疑难6 如何从表中获取多列和多行
※ 使用SQL语句获取行和列数据
※ 什么是关系数据库中的表
※ 一行在表中表示什么信息
※ 一列在表中表示什么信息
疑难7 如何通过唯一标识把两个表的数据连接在一起
※ 如何理解主键标识
1.3 SQL语句入门
疑难8 如何查询工作表中单列数据
※ 使用SQL获取单列数据
※ 什么是SELECT子句
疑难9 如何查询工作表中多列数据
※ 使用SQL语句获取多列数据
※ SQL列字段命名的限制
疑难10 如何查询工作表中的所有列数据
※ 如何理解SQL语句中的通配符
※ 什么叫别名
疑难11 如何使用列别名
※ 如何使用列别名
疑难12 如何使用DISTINCT查询工作表中不重复的记录
※ SQL语句中关键词DISTINCT的使用
疑难13 如何查询百度豪华车排行榜中某日搜索量大于800的记录
※ SQL语句中WHERE子句的使用
疑难14 如何在SQL中使用定义名称
※ 定义名称在SQL语句中的应用
※ 什么叫名称
疑难15 如何对学生的成绩进行降序排列
※ ORDER BY子句的使用
疑难16 如何不借助源数据表使用SQL语句
※ 什么情况下的SQL语句可以不使用FROM子句
疑难17 如何把一条新记录添加到数据源中
※ INSERT INTO语句的使用
疑难18 如何在Excel中更新数据
※ UPDATE语句的使用
疑难19 如何提取带有合并单元格的数据
※ 如何对包含合并单元格字段的工作表使用SQL语句
疑难20 如何解决查询结果中有空白记录的问题
※ 如何去除查询结果中出现的空白记录
1.4 练习与思考
第2章 SQL运算符使用
2.1 比较运算符
疑难21 如何查询报考某专业的考生
※ 为SQL设置条件查询子句
※ 不以第一行为起点的数据表示
※ 等号运算符
疑难22 如何查询字段值中包含双引号的数据
※ 包含引号的数据表示
疑难23 如何查询指定日期的出口数据
※ 日期型数据表示
疑难24 如何查询啤酒销量超过50kL的信息
※ 带有括号的字段名表示方式
※ 大于、小于等运算
疑难25 如何查询某班外同学的考试成绩
※ 不等号比较运算
2.2 逻辑运算符
疑难26 如何查询缺考同学的数据
※ NULL值的判断
疑难27 如何查询同时参加两项比赛的人员名单
※ IN运算的妙用
※ NOT IN运算出现NULL值时的注意事项
疑难28 如何查询2010年进入公司的员工名单
※ 利用BETWEEN求某范围内的数据
疑难29 如何查询姓“刘”的所有人员
※ 运用LIKE进行模糊匹配
※ 模糊匹配中不确定长度的字符表示
疑难30 如何查询订单号第三、四位为指定文本的出库记录
※ 模糊匹配中长度为1的字符表示
疑难31 如何查询成绩为C以上的同学
※ 模糊匹配中字符区间的表示
疑难32 如何查询商品代号中带有数字的商品数据
※ 模糊匹配中数字区间的表示
疑难33 如何查询姓名两端没有方括号的所有员工
※ 模糊匹配中特殊字符的表示
2.3 连接运算符
疑难34 如何对多个字段进行模糊查询
※ 连接符(&)的妙用
疑难35 如何查询同时满足申请租赁型经济适用房条件的人员
※ 同时满足多个条件的查询
疑难36 如何查询付款超过最后付款期限及尚未付款的客户
※ 满足多个条件之一的查询
2.4 算术运算符
疑难37 如何查询语数外总分大于240分的同学名单和总成绩
※ 字段的四则运算
※ 日期与数字的关系和转换
疑难38 如何计算员工社会保险缴纳金额
※ 按照百分比例计算字段
※ Excel中数字的精度
疑难39 如何根据点坐标计算距原点的距离
※ 幂运算的妙用
2.5 练习与思考
第3章 SQL常见函数使用
3.1 字符串函数
疑难40 如何根据二代身份证号返回出生年份
※ 四舍六入五单双的规则
※ MIDB函数的用法
※ 字符与字节的关系
疑难41 如何返回邮政机构所在行政区域
※ RIGHT函数与RIGHTB函数的区别
疑难42 如何分离联系电话的区号与电话号码
※ LEFT函数与LEFTB函数的区别
疑难43 如何替换字符串中的地名
疑难44 如何去除字符串首尾两侧的空格
※TRIM与LTRIM、RTRIM※
※ 空格与不可见字符
疑难45 如何返回字符串中某字符所在位置
疑难46 如何比较两列数据是否相同
※ CBOOL函数与STRCOMP函数用法比较
疑难47 如何查询有换行符字段的记录
疑难48 如何去除路径仅返回文件名
疑难49 如何将英文歌曲名称转换为小写字母
3.2 算术函数
疑难50 如何将价格进位到角得到产品零售价
疑难51 如何求出阳台的圆弧长度
疑难52 如何返回直角三角形斜边长度
※ 弧度与角度的转换
※ SQL中可用的其他三角函数
疑难53 如何将编码转换为十六进制数
※ 二进制、八进制、十六进制介绍
※ 进制转换方法简介
疑难54 如何根据货物重量返回满载车数量
3.3 转换函数
疑难55 如何统一项目起止的日期格式
疑难56 如何格式化出货量增长率
疑难57 如何整理投票结果并返回读书数量
疑难58 如何将数字转换为字符
※ CSTR函数与STR函数的区别
疑难59 如何将字符转换成数字
※ CDBL函数、CSNG函数及CVAR函数用法比较
3.4 其他函数
疑难60 如何根据学生成绩返回等第成绩
疑难61 如何得到调整后的工资额
※ ISNUMERIC函数
疑难62 如何得到反转后的回文诗
疑难63 如何按规定格式返回数字与文本混杂的数据
※ 纯小数前是否显示前导0
疑难64 如何查看支出是否超出预算
疑难65 如何根据二代身份证号码判断性别
3.5 练习与思考
第4章 SQL日期和时间函数使用
4.1 获取日期
疑难66 如何查询今天是星期几
※ 关于星期的典型语句
疑难67 如何用SQL语句得到当前月的剩余天数
疑难68 如何用SQL判断今年是平年还是闰年
※ 判断平年或闰年的语句
疑难69 如何用SQL获取今年母亲节的日期
疑难70 如何用SQL计算员工的工龄工资
疑难71 如何用SQL计算食品到期日期
4.2 格式化日期
疑难72 如何将日期和时间转换为系统标准格式
※ 利用FORMAT函数转换日期
疑难73 如何获取合同签订的英文日期
※ 利用FORMAT函数转换为英文日期
※ 利用函数复合运用转换为英文日期
疑难74 如何将日期转换为报表所需格式
※ 获取当月总天数的技巧
4.3 时间段查询
疑难75 如何返回第一季度中的销售记录
※ DATEPART函数忽略年份获取日期所在的季度
疑难76 如何提取合同即将到期的员工及最迟续订期限
※ 利用WEEKDAY函数获取工作日信息
疑难77 如何获取所有职员的星座
※ 不同年份查询相同月份、日期所在区间
※ 笛卡儿积的概念
疑难78 如何找出销售额最高的月份
※ 利用MONTHNAME函数获取月份的完整表示
疑难79 如何查询库存中某日的出入库情况汇总
※ 日期和时间的关系
4.4 练习与思考
第5章 SQL排序查询
5.1 单列数据排序
疑难80 如何提取某区域的销售记录并按销售额降序排列
※ 利用ORDER BY子句对记录进行排序
※ SQL查询机制步骤详解
疑难81 如何找出考试成绩总分前5名的同学
※ 利用TOP谓词查询前几条记录
※ TOP PERCENT保留记

Specifications

Brand Jingdong book
Brand Origin China

Disclaimer

Product packaging, specifications and price are subject to change without notice. All information about the products on our website is provided for information purposes only. Please always read labels, warnings and directions provided with the product before use.

View Full Terms of Use
Add to favorites
{{ $isZh ? coupon.coupon_name_sub : coupon.coupon_ename_sub | formatCurrency }}
{{__("Buy Directly")}} {{ itemCurrency }}{{ item.directly_price }}
Quantity
{{ quantity }}
{{ instockMsg }}
{{ limitText }}
{{buttonTypePin == 3 ? __("Scan to view more PinGo") : __("Scan to start")}}
Sold by JD@CHINA
Ship to
{{ __("Ship to United States only") }}
Free shipping over 69
Genuine guarantee

Added to Cart

Keep Shopping

More to Consider

{{ item.brand_name }}

{{ item.item_name }}

{{ item.currency }}{{ item.market_price }}

{{ item.currency }}{{ item.unit_price }}

{{ item.currency }}{{ item.unit_price }}

Coupons

{{ coupon.coupon_name_new | formatCurrency }}
Clip Clipped Over
{{ getCouponDescStr(coupon) }}
{{ coupon.use_time_desc }}
Expires soon {{ formatTime(coupon.use_end_time) }}

Share this item with friends

Cancel

Yami Gift Card

Get this exclusive deal when paying with gift card

Terms and Conditions

Gift card deals are special offers for selected products;

The gift card deals will automatically be activated if a customer uses gift card balance at check out and the balance is sufficient to pay for the total price of the shopping cart products with gift card deals;

You will not be able to activate the gift card deals if you choose other payment methods besides gift card. The products will be purchased at their normal prices;

If your account balance is not enough to pay for the products with gift card deals, you can choose to reload your gift card balance by clicking on the Reload button at either shopping cart page or check out page;

Products that have gift card deals can be recognized by a special symbol showing 'GC Deal';

For any additional questions or concerns, please contact our customer service;

Yamibuy reserves the right of final interpretation.

Sold by Yami

Service Guarantee

Yami Free Shipping over $49
Yami Easy Returns
Yami Ships from United States

Shipping

  • United States

    Standard Shipping is $5.99 (Excluding Alaska & Hawaii). Free on orders of $49 or more.

    Local Express is $5.99 (Available in Parts of CA, NJ, MA & PA). Free on orders of $49 or more.

    2-Day Express (Includes Alaska & Hawaii) starts at $19.99.

Return Policy

Yami is committed to provide our customers with a peace of mind when purchasing from us. Most items shipped from Yamibuy.com can be returned within 30 days of receipt of shipment (For Food, Beverages, Snacks, Dry Goods, Health supplements, Fresh Grocery and Perishables Goods, within 7 days of receipt of shipment due to damages or quality issues; To ensure that every customer receives safe and high-quality products, we do not provide refunds or returns for beauty products once they have been opened or used, except in the case of quality issues; Some products may have different policies or requirements associated with them, please see below for products under special categories, or contact Yami Customer Service for further assistance).
Thank you for your understanding and support.

Learn More

Sold by Yami

Terms and Conditions of Yami E-Gift Card

If you choose “Redeem automatically” as your delivery method, your gift card balance will be reload automatically after your order has been processed successfully;

If you choose “Send to Email”as your delivery method, the card number and CVV will be sent to the email address automatically;

Any user can use the card number and CVV to redeem the gift card, please keep your gift card information safely. If you have any trouble receiving email, please contact Yami customer service;

Yami gift card can be used to purchase both Yami owned or Marketplace products;

Yami gift card will never expire;

Yami gift card balance does not have to be used up at once;

All rights reserved by Yami.

Return Policy

Gift card that has already been consumed is non-refundable.

Sold by JD@CHINA

Service Guarantee

Yami Free Shipping over $49
Yami Easy Returns
Yami Ships from United States

Shipping

  • United States

    Standard Shipping is $5.99 (Excluding Alaska & Hawaii). Free on orders of $49 or more.

    Local Express is $5.99 (Available in Parts of CA, NJ, MA & PA). Free on orders of $49 or more.

    2-Day Express (Includes Alaska & Hawaii) starts at $19.99.

Return Policy

You may return product within 30 days upon receiving the product. Items returned must be new in it's original packing, including the original invoice for the purchase. Customer return product at their own expense.

Sold by JD@CHINA

Service Guarantee

Yami Cross-store Free Shipping over $69
Yami 30-days Return

Yami-China FC

Yami has a consolidation warehouse in China which collects multiple sellers’ packages and combines to one order. Our Yami consolidation warehouse will directly ship the packages to your door. Cross-store free shipping over $69.

Return Policy

You may return products within 30 days upon receiving the products. Sellers take responsibilities for any wrong shipment or missing items. Packing needs to be unopened for any other than quality issues return. We promise to pack carefully, but because goods are taking long journey to destinations, simple damages to packaging may occur. Any damages not causing internal goods quality problems are not allowed to return. If you open the package and any quality problem is found, please contact customer service within three days after receipt of goods.

Shipping Information

Yami Consolidation Service Shipping Fee $9.99(Free shipping over $69)

Sellers in China will ship their orders within 1-2 business days once the order is placed. Packages are sent to our consolidation warehouse in China and combined there. Our Yami consolidation warehouse will directly ship the packages to you via UPS. The average time for UPS to ship from China to the United States is about 10 working days and it can be traced using the tracking number. Due to the pandemic, the delivery time may be delayed by about 5 days. The package needs to be signed by the guest. If the receipt is not signed, the customer shall bear the risk of loss of the package.

Sold by JD@CHINA

Service Guarantee

Free shipping over 69
Genuine guarantee

Shipping

Yami Consolidated Shipping $9.99(Free shipping over $69)


Seller will ship the orders within 1-2 business days. The logistics time limit is expected to be 7-15 working days. In case of customs clearance, the delivery time will be extended by 3-7 days. The final receipt date is subject to the information of the postal company.

Yami Points information

All items are excluding from any promotion or points events on Yamibuy.com

Return Policy

You may return product within 30 days upon receiving the product. Items returned must be new in it's original packing, including the original invoice for the purchase. Customer return product at their own expense.

Yami

Download the Yami App

Back Top

Recommended for You

About the brand

Jingdong book

为您推荐

Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折

Reviews{{'('+ commentList.posts_count + ')'}}

Have your say. Be the first to help other guests.

Write a review
{{ totalRating }} Write a review
  • {{i}} star

    {{i}} stars

    {{ parseInt(commentRatingList[i]) }}%

Yami Yami
{{ comment.user_name }}

{{ showTranslate(comment) }}Show Less

{{ strLimit(comment,800) }}Show more

Show Original

{{ comment.content }}

Yami
Show All

{{ formatTime(comment.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ comment.likes_count }} {{ comment.likes_count }} {{ comment.reply_count }} {{comment.in_user==uid ? __('Delete') : __('Report')}}
Yami Yami
{{ comment.user_name }}

{{ showTranslate(comment) }}Show Less

{{ strLimit(comment,800) }}Show more

Show Original

{{ comment.content }}

Yami
Show All

{{ formatTime(comment.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ comment.likes_count }} {{ comment.likes_count }} {{ comment.reply_count }} {{comment.in_user==uid ? __('Delete') : __('Report')}}

No related comment~

Review

Yami Yami

{{ showTranslate(commentDetails) }}Show Less

{{ strLimit(commentDetails,800) }}Show more

Show Original

{{ commentDetails.content }}

Yami
Show All

{{ formatTime(commentDetails.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ commentDetails.likes_count }} {{ commentDetails.likes_count }} {{ commentDetails.reply_count }} {{commentDetails.in_user==uid ? __('Delete') : __('Report')}}

Please write at least one word

Comments{{'(' + replyList.length + ')'}}

Yami Yami

{{ showTranslate(reply) }}Show Less

{{ strLimit(reply,800) }}Show more

Show Original

{{ reply.reply_content }}

{{ formatTime(reply.reply_in_dtm) }}

{{ reply.reply_likes_count }} {{ reply.reply_likes_count }} {{ reply.reply_reply_count }} {{reply.reply_in_user==uid ? __('Delete') : __('Report')}}

Please write at least one word

Cancel

That’s all the comments so far!

Write a review
How would you rate this item?

Please add your comment.

  • A nice nickname will make your comments more popular!
  • The nickname in your account will be changed to the same as here.
Thanks for your review
Our community rely on great reviews like yours to find the best of Asia.

Report

If you find this content inappropriate and think it should be removed from the Yami.com site, let us know please.

Cancel

Are you sure to delete your review?

Cancel

You’ve Recently Viewed

About the brand

Jingdong book