Computer Science
The …………… clause of SELECT query allows us to select only those rows in the result that satisfy a specified condition.
- Where
- from
- having
- like
SQL Queries
3 Likes
Answer
Where
Reason — The WHERE clause in SELECT statement specifies the criteria for selection of rows to be returned. When a WHERE clause is present, the database program goes through the entire table one row at a time and examines each row to determine if the given condition is true. If it is true for a row, that row is displayed in the output.
Answered By
1 Like
Related Questions
Which of the following keywords will you use in the following query to display the unique values of the column dept_name ?
SELECT ............... dept_name FROM Company;- All
- From
- Distinct
- Name
Which of the following keywords will you use in the following query to display all the values of the column dept_name ?
SELECT ............... dept_name FROM Company;- All
- From
- Distinct
- Name
…………… clause of the following query must be added with keyword …………… to display the fields given in the select list as per a given condition.
SELECT ID, name, dept name, salary * 1.1 WHERE instructor = 1005 ;- where, having
- select, from
- where, from
- where, select
Which of the following queries contains an error?
- Select * from emp where empid = 10003;
- Select empid from emp where empid = 10006;
- Select empid from emp;
- Select empid where empid = 1009 and lastname = 'GUPTA';