Querying data using SQL statements in Excel (iii)

Two blog posts to share with you how to create a data source connection, we then use SQL statements for data analysis. I'm still more comfortable with the way Microsoft Query is connected.

See, it's a data source. We're going to find out from the data source that employees who are in New York and gender male

650) this.width=650; "style=" Float:none; "title=" 31.JPG "src=" http://s3.51cto.com/wyfs02/M02/6D/05/ Wkiol1vaphghzeyhaalpcfyc0aw687.jpg "alt=" Wkiol1vaphghzeyhaalpcfyc0aw687.jpg "/>

Procedure for creating a Microsoft Query connection I skipped it.

The SQL Statement Edit window appears after you click SQL in the window. Take a detailed look at the statement

SELECT Employee, Location,sex

from sheet1$

WHERE location= ' New York '

Note: SELECT to control the output of the column

WHERE to control the output of the row

The above statement shows the Employee column location column and the sex column that match the data rows of the location column that are New York and display all the data

650) this.width=650; "style=" WIDTH:807PX;FLOAT:NONE;HEIGHT:417PX; "title=" 32.JPG "src=" http://s3.51cto.com/wyfs02/ M02/6d/0a/wkiom1vapjzwwaskaan2h90bufw304.jpg "width=" 922 "height=" 507 "alt=" wkiom1vapjzwwaskaan2h90bufw304.jpg "/ >

The results are as follows, and the results are returned to the Excel worksheet

650) this.width=650; "style=" Float:none; "title=" 33.JPG "src=" http://s3.51cto.com/wyfs02/M00/6D/05/ Wkiol1vaphuhseqjaajtloowxiw933.jpg "alt=" Wkiol1vaphuhseqjaajtloowxiw933.jpg "/>

The results are as follows.

650) this.width=650; "style=" Float:none; "title=" 34.JPG "src=" http://s3.51cto.com/wyfs02/M00/6D/0A/ Wkiom1vapkorgsvgaaev_nxlook711.jpg "alt=" Wkiom1vapkorgsvgaaev_nxlook711.jpg "/>

This article is from the "Guo Yong Technology blog" blog, make sure to keep this source http://guoyong.blog.51cto.com/408495/1652676

Querying data using SQL statements in Excel (iii)