Home >> Oracle >> AND Clause in Oracle

AND Clause in Oracle

AND clause used to check multiple condtion with a WHERE clause from a table in database.

It is used in SELECT,UPDATE and DELETE query.

Syntax

SELECT * FROM tablename WHERE condition1 AND condition2 AND condition3;

Example

SELECT * FROM students WHERE student_id>1 AND city='Delhi'

Post Your Comment

Next Questions
OR Clause
LIKE clause
IN clause
ORDER BY Clause
GROUP BY Clause
HAVING Clause
BETWEEN
EXISTS
NOT EXITS
ANY
ALL
MAX
MIN
AVG
COUNT
SUM
What is key
What is Super Key
What is Candidate Key
What is Primary Key
What is Unique Key
What is Foreign Key
Function
Procedure
Cursor

Copyright ©2022 coderraj.com. All Rights Reserved.