1 | SELECT *FROM Sales WHERE YEAR(Date) > 2004 AND Amount > 1000 |
1 2 | SQL 1:select * from lineitem where l_orderkey = ? SQL 2:select l_suppkey, l_partkey from lineitem where l_orderkey = ? |
1 | Date > ‘ 2004-12-31 ’ |
1 | Function(Column_A)= ‘ constant ’ |
1 | Column_A=Inverse_Function( ‘ constant ’ ) |
1 2 3 4 | SQL 3:select l_quantity, l_comment from lineitem where l_orderkey + 100 = 200 SQL 4:select l_quantity, l_comment from lineitem where l_orderkey = 100 |
欢迎光临 电子技术论坛_中国专业的电子工程师学习交流社区-中电网技术论坛 (http://bbs.eccn.com/) | Powered by Discuz! 7.0.0 |