Sep 9, 2019 in Spark Sql
Q:

SQL Syntax

1 Answer

0 votes
Sep 9, 2019

Database Tables

A database most often contains one or more tables. Each table is identified by a name (e.g. "Customers" or "Orders"). Tables contain records (rows) with data.

In this tutorial we will use the well-known Northwind sample database (included in MS Access and MS SQL Server).

SQL Statements

Most of the actions you need to perform on a database are done with SQL statements.

The following SQL statement selects all the records in the "Customers" table:

Example

SELECT * FROM Customers;

Click here to read more about Loan/Mortgage
Click here to read more about Insurance
...