Versions Compared

Old Version 8

changes.mady.by.user Nadine Hinojosa

Saved on

compared with

New Version 9

changes.mady.by.user Nadine Hinojosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The SELECT clause is used to select data from an Excel worksheet.

SELECT * | COUNT(*) | column1, column2, ...

SELECT * | column1 [AS alias1], column2 [AS alias2] 

Example

Code Block
SELECT * FROM Sheet1
GO
SELECT city, zipcode FROM zips
GO
SELECT COUNT(*) FROM zips
GO
SELECT SUM(population) AS [Total Population] FROM zips
GO

...