简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

循序渐进学Oracle之复杂查询(重点)

WBOY
Release： 2016-06-07 17:38:00
Original
1123 people have browsed it

前言在实际应用中经常需要执行复杂的数据统计,经常需要显示多张表的数据,故必须要高度重视:复杂的select语句!1-数据分组的重要函数:max、min、avg、sum、count(1

前言

在实际应用中经常需要执行复杂的数据统计,经常需要显示多张表的数据,故必须要

范例：

073703694.jpg

没有40部门，我们换成RIGHT JOIN…ON ，如下图所示：

073949376.jpg

由上可知：40部门出现了！

在Oracle之外的数据库（SQLSERVER、MYSQL、DB2等）都使用以上的SQL：1999语法操作，故必须要会！（当然，，一直使用Oracle数据库，就可以不会：））

再次强调：多表查询的性能肯定不高，而且性能一定要在大数据量的情况下，才能发现。


本文出自 “beyondhedefang” 博客，请务必保留此出处

Related labels：
Complex query
source：php.cn
Previous article： hbase安装 Next article： 在SQL 2012中使用和Oracle 一样的序列
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
How to optimize tp6 query When the tp6 model is associated with multiple data tables for query, the query will be ve...
From 2023-11-17 08:50:36
0
0
84
Prevent MySQL from reading when updating I have two simple queries, one to read the table and one to update the table. How to lock ...
From 2023-11-07 18:05:53
0
1
203
Is full count query really that slow on a large MySQL InnoDB table? We have a large table with millions of entries. Full counting is very slow, see code below...
From 2023-11-07 15:52:43
0
2
236
Passing PHP variables to SQL query in oci_parse I'm passing PHP variables into an OracleSQL query. But it's not treating it properly and g...
From 2023-11-04 12:38:22
0
1
306
Insert conversion using MySQL I'm trying to insert a value into a table in MySQL but can't get it to work. I'm using the...
From 2023-11-02 19:47:58
0
2
286
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！