Ana içeriğe atla SQL Queries

WavePoint Co. Ltd.

3.0 (2)

Run SQL queries in Excel and directly against Excel tables.

When you work with large Excel spreadsheets, tasks like joining several tables into one, removing duplicates, complex filtering, grouping, sorting, etc. become a challenge. SQL Queries App offers a new approach to accomplish these tasks easily. Now users who are familiar with structured query language can run SQL queries directly against Excel tables. Here is just a short list of what you can do:

• Automatically generate SELECT and JOIN queries and edit them manually

• Work with many tables in any open spreadsheet using SELECT queries

• Join two or more tables by a key column using JOIN statements

• Remove duplicates using DISTINCT or GROUP BY statements

• Apply complex filtering with a certain criteria using WHERE statements

• Apply complex sorting, grouping and aggregation using SUM, COUNT, MIN, MAX statements, and much more!

Eklenti özellikleri
Bu eklenti, kullanıldığında şunları yapabilir:
  • Belgenizi okuyabilir veya belgenizde değişiklik yapabilir
  • İnternet üzerinden veri gönderebilir