fork download
copy 
  1. SELECT 
  2.     `供应商编码`,
  3.     `供应商名称`,
  4.     `计划编号`,
  5.     `物料名称`,
  6.     `预算总价`,
  7.     `最终报价`,
  8.     ROUND((`最终报价` - `预算总价`) / `预算总价`, 4) AS `预算偏离度`,
  9.     CONCAT(ROUND(((`最终报价` - `预算总价`) / `预算总价`) * 100, 2), '%') AS `预算偏离度百分比`,
  10.     `报价排名`
  11. FROM `供应商信息表`
  12. WHERE `预算总价` > 0 
  13.   AND (`最终报价` - `预算总价`) / `预算总价` > 0.3
  14.   OR (`最终报价` - `预算总价`) / `预算总价` < 0.3
  15. ORDER BY `预算偏离度` DESC;
Success #stdin #stdout #stderr 0.01s 5288KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Error: near line 1: no such table: 供应商信息表
https://ideone.com/oD2RLu
language:
SQLite (sqlite 3.27.2)
created:
4 days ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!