- 博客(6)
- 收藏
- 关注
翻译 Oracle Database 12c: SQL Workshop I: 07 Displaying Data from Multiple Tables Using Joins
Displaying Data from Multiple Tables Using JoinsJoining Tables Using SQL:1999 SyntaxSELECT table1.column, table2.column FROM table1[NATURAL JOIN table2] |[JOIN table2 USING (column_name)] | [...
2018-09-03 23:19:22 174
翻译 Oracle Database 12c: SQL Workshop I: 06 Reporting Aggregated Data Using the Group Functions
Reporting Aggregated Data Using the Group FunctionsGroup functions Group functions operate on sets of rows to give one result per group The COUNT function has three formats: • COUNT...
2018-09-01 15:58:20 159
翻译 Oracle Database 12c: SQL Workshop I: 05 Using Conversion Functions and Conditional Expressions
Using Conversion Functions and Conditional ExpressionsConversion Functions In some cases, the Oracle server receives data of one data type where it expects data of a different data type. When th...
2018-08-31 23:40:33 221
翻译 Oracle Database 12c: SQL Workshop I: 04 Using Single-Row Functions to Customize Output
Using Single-Row Functions to Customize Output Single-row functions are used to manipulate data items. They accept one or more arguments and return one value for each row that is returned by the q...
2018-08-29 23:32:04 162
翻译 Oracle Database 12c: SQL Workshop I: 03 Restricting and Sorting Data
Restricting and Sorting DataLimiting rows with:——The WHERE clauseSELECT *|{[DISTINCT] column|expression [alias],...}FROM table[WHERE logical expression(s)];——The comparison conditions using ...
2018-08-27 23:55:36 198
翻译 Oracle Database 12c: SQL Workshop I: 02 Retrieving Data Using the SQL SELECT Statement
Retrieving Data Using the SQL SELECT StatementBasic SELECT StatementSELECT {*|[DISTINCT] column|expression [alias],...}FROM table;NULL values in the SELECT statement Null is a value that ...
2018-08-27 23:54:30 142
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人