Questions about case
Read more about case
python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
Case condition not working for ORA-01476: divisor is equal to zero
I have a logic where doing some calculation like below is giving error as
ORA-01476: divisor is equal to zero
I have added CASE condition like below
V_EFFEC_PER_APPFAIR := (case when v_YEARMSAFORAPP...
Nad
Votes: 0
Answers: 1
select-from-where-and-case How can I make these work together?
with rows as
(select
candidate,
decision,
comments,
candidate
scores,
rankings
from
candidate_decision_file,
candidate_info_file
where candidate_decision_file.candidate = candidate_info_file....
PN567890
Votes: 0
Answers: 1
Using if-then or case-when-then to select from dataset
I have a dataset with students in 1st, 2nd and 3rd grades. I want to select the names of all students in 1st and 2nd grades, but only students named John, Jane or Smith from 3rd grade. Here is what I ...
PN567890
Votes: 0
Answers: 2
Can I use CASE statement with a JOIN?
I have 2 tables with values:
CREATE TABLE students (
ids int AUTO_INCREMENT PRIMARY KEY,
name varchar(100) DEFAULT NULL,
surname varchar(100) DEFAULT NULL
);
CREATE TABLE register (
idr i...
Lucica Savin
Votes: 0
Answers: 1