Scribd
Upload
2 views3 pages

Excel vs. SQL Terms

The document compares common terms used in Excel and SQL, providing equivalent terminology for each. It lists various functions and features from both tools, such as IF() in Excel being equivalent to CASE in SQL. The comparison aids in understanding how similar concepts are represented in each software.

Uploaded by

shanurudra177
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views3 pages

Excel vs. SQL Terms

The document compares common terms used in Excel and SQL, providing equivalent terminology for each. It lists various functions and features from both tools, such as IF() in Excel being equivalent to CASE in SQL. The comparison aids in understanding how similar concepts are represented in each software.

Uploaded by

shanurudra177
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Vs.

Comparison of
Common Terms

Esther Onyebuchi
Excel vs. SQL
Excel SQL

Row Record

Column Field

Worksheet Table

Workbook Database

IF() CASE

VLOOKUP() JOIN

Esther Onyebuchi
Excel vs. SQL
Excel SQL

Sort ORDER BY

Filter WHERE

TODAY() GETDATE()

UNIQUE() DISTINCT

Import Data LOAD DATA

Conditional Formatting CASE WHEN

Esther Onyebuchi

You might also like