WHERE CLAUSE IN ORACLE SQL



 WHERE CLAUSE


SELECT column1, column2, ...

FROM table_name

WHERE condition;



For example, if you want to retrieve all the rows from a table called "employees" where the salary is greater than 50000, you would use the following SQL query:


SELECT *

FROM employees

WHERE salary > 50000;


OUTPUT














Post a Comment

Previous Post Next Post