SQL then compares the value that results from the subquery with the value on the other side of the comparison operator. The value can be the result of an arithmetic expression or a column function. The subquery can return at most one value. Sample Output: employee_id | last_name | caseĪ subquery can be used before or after any of the comparison operators. SELECT department_id from departments WHERE location_id=2500) ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |