python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - where-clause

Selecting fields from multiple tables with Where and Substr

Not sure what I'm doing wrong here. I've been trying all week and can't find the problem. I'm new to oracle so I'm hoping it's something easy I'm missing. My script is below. I'm trying to pull stu...
test-img

user17986852

sql

oracle

select

where-clause

substr

Votes: 0

Answers: 1

Latest Answer

There is a stray || after t.email_addr, and the line with '' before the FROM clause shouldn't be there. select s.student_number||','|| s.first_name||','|| s.last_name||','|| s.schoolID...
test-img

William Robertson

Use one of two dates in where clause

I need to delete all records in a table where the CreatedDate or ModifiedDate is greater than x. The logic is as follows: If ModifiedDate is not null then use this value Otherwise use the CreatedDate...
test-img

Newman

sql

date

where-clause

Votes: 0

Answers: 2

Latest Answer

Use case statment Delete * From tableX CASE WEHN ModifiedDate is not null and < Getdate() - 30 THEN -- your logic Else -- CreateDate < Getdate() - 30 END
test-img

user123456

Filter result from a single name in a SET with multiple entries

I have a column of SET type made up of creators of comic books. In PHP, I do a query to get all the comics with a single creator. If I do a query using WHERE creator = "John Byrne", I can se...
test-img

Mehdi Bouhalassa

php

mysql

list

set

where-clause

Votes: 0

Answers: 0

Using Case in WHERE condition MYSQL

Is it possible to use CASE statement in WHERE condition like below? SELECT act.id_activity FROM activity act LEFT JOIN work w ON w.id_work = act.id_work WHERE w.work_type=1 AND w.work_tender in (1,2)...
test-img

wanna

mysql

sql

where-clause

Votes: 0

Answers: 3

Latest Answer

You can try to write correct logic by OR & AND. SELECT act.id_activity FROM activity act LEFT JOIN work w ON w.id_work = act.id_work WHERE w.work_type=1 AND ( (act.id_activity_type IN ('2','3...
test-img

D-Shih

Posts

Questions

Blogs

Jobs