trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From li...@apache.org
Subject [trafodion] 01/02: Incorporate comments 2
Date Tue, 19 Mar 2019 05:33:35 GMT
This is an automated email from the ASF dual-hosted git repository.

liuyu pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/trafodion.git

commit 42f07bf0d7f671176dc0cf96ff76ab3492a0c9df
Author: Yu Liu <qwertyioz@hotmail.com>
AuthorDate: Tue Mar 19 11:45:48 2019 +0800

    Incorporate comments 2
---
 .../asciidoc/_chapters/sql_functions_and_expressions.adoc | 15 +++++++++------
 1 file changed, 9 insertions(+), 6 deletions(-)

diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
index 7ab0671..680413a 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
@@ -7146,13 +7146,16 @@ VENDOR_ID VENDOR_NAME    VENDOR_EMAIL           VENDOR_EMAIL_ID
 
 +
 ```
-SELECT PIVOT(vendor_id), PIVOT(vendor_email) FROM vendor GROUP BY vendor_id;
+SELECT vendor_id, PIVOT(vendor_email) FROM vendor GROUP BY vendor_id;
+
+VENDOR_ID (EXPR)                                                                        
                                                 
+--------- --------------------------------------------------------------------------------------------------------------------------------
+      111 tom@hotmail.com                                                               
                                                 
+      232 jerry@gmail.com,jerry@hotmail.com                                             
                                                 
+      367 aven@gmail.com,aven@hotmail.com,aven@outlook.com                              
                                                 
+
+--- 3 row(s) selected.
 
-(EXPR)           (EXPR)                                                                 
                                                        
----------------- ----------------------------------------------------
-111              tom@hotmail.com                                                        
                                                        
-232,232          jerry@gmail.com,jerry@hotmail.com                                      
                                                        
-367,367,367      aven@gmail.com,aven@hotmail.com,aven@outlook.com 
 ```
 
 +


Mime
View raw message