SQL WHERE - Introduction and syntax
Explain the SQL WHERE statement. Write SQL syntax for the SQL WHERE statement
along with an example.
WHERE: It is used to fetch records that fulfill a specified
condition.
Syntax:
SELECT column_name(s) FROM table_name WHERE column_name operator value
Example:
SELECT balance FROM Account WHERE balance > 1000
Also read
Answer - The start and end of each
transaction......
Answer - It is created when CHECKPOINT statement
is executed.......
Answer - It is the process of organizing data
into related table. To normalize database, we divide database into
tables.....
Answer - The column or columns of the table
whose value uniquely identifies each row in the table is called
primary key. You can define column as primary key using primary key
constraint while you create
table.....
|
