How to Retrieve Data From From a Single Table in SQL

Posted in SQL | SQL Query on June 26, 2019

Tags: sql, Select clause, from clause, where clause, order by clause

In this article I am going to explain about how to retrieve data from a single table.

2732

Introduction

In this article I am going to explain about how to retrieve data from a single table. We use SELECT statement to retrieve data from table. There are four clause in SELECT statement which are used to retrieve data from table.

SELECT clause is used to describe the column that will be included in the result set.
FROM clause is used to names the table from which the query will retrieve the data.
WHERE clause is used to specifies the conditions in query.
ORDER BY clause is used to specifies how the rows in the result set will be stored.

A Statement that is used to fetch data from invoices table