Where Clause
- In the following query “person_id” can be
SELECT Emp_id, fname,Lname, Birth_date FROM Employee
WHERE Emp_id=101;
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
Primary Key or any other Attribute
- Which Clause is used to select a particular row from the set of row in an existing table?
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
WHERE
- What will be the output of the query given below?
SELECT emp_id, fname, lname
FROM employee
WHERE title='Manager’ AND start_date > 2016-03-20;
-
View Hint View Answer Discuss in Forum
NA
Correct Option: A
Columns mention with “SELECT” clause and only those rows which contain ‘Manager’ as a “title” and start_date > 2016-03-20
- What will be the output of the query given below?
SELECT Student_id, FirstName, LastName
FROM Student
WHERE title=’Monitor’ AND start_date=2017-02-25;
-
View Hint View Answer Discuss in Forum
NA
Correct Option: B
“WHERE” clause is used to filter out unwanted rows and “SELECT” clause is used to select columns from table.
- What will be the output of the query given below?
SELECT Id, FirstName, LastName
FROM Student
WHERE title=’Monitor’;
-
View Hint View Answer Discuss in Forum
NA
Correct Option: A
“WHERE” clause is used to filter out unwanted rows and “SELECT” clause is used to select columns from table.