Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
I have a query and I want to use if statement inside where clause like this : [code] SELECT e.first_name, e.last_name, e.status FROM employees e WHERE IF status_flag = STATUS_ACTIVE then e.status = 'A' IF status_flag = STATUS_INACTIVE then e.status = 'T' IF source_flag = SOURCE_FUNCTION then e.business_unit = ...
hello can I use select inside if statement like : begin if (select count(*) from employees) >= 15 then do something; end if; end; note : I want to delete rows from table where above condition evaluates with true
