OPTIONALLY

MySQL

Example

SELECT * FROM Employees

Output

+------------+----------+---------+
| EmployeeId | Name     | Position|
+------------+----------+---------+
| 1          | John Doe | Manager |
| 2          | Jane Doe | Analyst |
+------------+----------+---------+

Explanation

In the above example, we use ‘SELECT * FROM Employees’ SQL statement in the markdown format to display all data from the Employees table. The output is displayed in a tabulated format with EmployeeId, Name, and Position as columns.

PostgreSQL

Example

SELECT * FROM employees;

Output

| id |  name   |  role   |
|----|---------|---------|
| 1  | John    | Manager |
| 2  | Jane    | Analyst |
| 3  | Sam     | Engineer|

Explanation

The SQL query SELECT * FROM employees; gathers all records from the employees table. The output is formatted in markdown to present an easily readable table.

SQL Server

Example

Markdown for SQL code:

SELECT *
FROM Customers;

Markdown for output:

ID | NAME  | AGE | ADDRESS  | SALARY
---|-------|-----|----------|------
1  | Ramesh| 32  | Ahmedabad| 2000.00
2  | Khilan| 25  | Delhi    | 1500.00
3  | Kaushik| 23 | Kota     | 2000.00
4  | Chaitali| 25| Mumbai   | 6500.00
5  | Hardik | 27| Bhopal   | 8500.00
6  | Komal  | 22| MP       | 4500.00
7  | Muffy  | 24| Indore   | 10000.00

Output

ID	NAME	AGE	ADDRESS	SALARY
1	Ramesh	32	Ahmedabad	2000.00
2	Khilan	25	Delhi	1500.00
3	Kaushik	23	Kota	2000.00
4	Chaitali	25	Mumbai	6500.00
5	Hardik	27	Bhopal	8500.00
6	Komal	22	MP	4500.00
7	Muffy	24	Indore	10000.00

Explanation

This is an example of displaying a table from SQL Server Database. The “SELECT *” command is used to select all the columns from the “Customers” table. Markdown is used to format the SQL code and the corresponding output. The formatted SQL code is enclosed within sql and , and the formatted output is enclosed within and to differentiate it from other text.

Oracle

Example

SELECT * FROM Employees;

Output

| EmployeeId | LastName | FirstName | HireDate   |
|------------|----------|-----------|------------|
| 1          | Doe      | John      | 2010-04-12 |
| 2          | Smith    | Jane      | 2012-05-20 |
| 3          | Brown    | Paul      | 2009-08-15 |

Explanation

In the example shown above, the SQL statement is written to query all existing records from the Employees table. The output is then displayed in a Markdown-formatted table. Each row corresponds to a distinct record in the table. The columns represent different fields of the record such as EmployeeId, LastName, FirstName, and HireDate.

SQLite

Example

CREATE TABLE Employees
(
  ID int,
  Name varchar(255),
  Salary float,
  StartDate date,
  City varchar(255),
  Region char(1)
);

INSERT INTO Employees
VALUES (1, 'John', 70000, '2013-01-01', 'New York', 'N'),
(2, 'Mike', 80000, '2014-01-01', 'Boston', 'E'),
(3, 'Amy', 50000, '2013-01-01', 'Chicago', 'W'),
(4, 'Jessica', 60000, '2012-01-01', 'Seattle', 'W');

SELECT * FROM Employees;

Output

| ID | Name    | Salary | StartDate | City    | Region |
|----|---------|--------|-----------|---------|--------|
| 1  | John    | 70000  | 2013-01-01| New York| N      |
| 2  | Mike    | 80000  | 2014-01-01| Boston  | E      |
| 3  | Amy     | 50000  | 2013-01-01| Chicago | W      |
| 4  | Jessica | 60000  | 2012-01-01| Seattle | W      |

Explanation

The SQL code in this example first creates a table named “Employees” with specific attributes. The “INSERT INTO” statement is then used to populate the table with data. The final statement is a “SELECT *” command, which selects and displays all records from the table. The output shows the table displayed in markdown format with four rows of data that match the inserted records. Each row represents an employee record and displays details such as employee ID, name, salary, start date, city, and region.