Question

Write SQL statement to select records from student table whose fee is more than 4000.​

Answer 1

Answer:

select * from student where fee>4000;

Explanation:

* selects all the records that satisfy the given condition

Answer 2

The basic form of the SELECT statement is SELECT-FROM-WHERE block. In a SELECT statement, WHERE clause is optional. Using SELECT without a WHERE clause is useful for browsing data from tables.

In a WHERE clause, you can specify a search condition (logical expression) that has one or more conditions. When the condition (logical expression) evaluates to true the WHERE clause filter unwanted rows from the result.