SELECT statement in RDBMS

SELECT statement allows you to retrieve records from one or more tables in your database.

Syntax

SELECT column FROM table WHERE predicates

Example

SELECT *FROM supplier WHERE city='India'