Tag Info

New answers tagged select

1 vote

Accepted

How do I SELECT elements using WHERE with another table's record values in WHERE statement?

the downtime started at timestamp x and ended at timestamp y. I want to return the last tracked message in channel z before timestamp x Does this achieve that? SELECT ... FROM t WHERE channel ...

Rick James

69.4k

answered Jul 17 at 1:21

Top 50 recent answers are included

1,020

questions tagged

select

select × 1020
mysql × 431
postgresql × 159
sql-server × 133
join × 104
oracle × 89
performance × 73
query × 58
group-by × 44
insert × 42
count × 40
query-performance × 38
update × 34
subquery × 33
index × 31
sqlite × 28
mariadb × 26
optimization × 26
distinct × 23
order-by × 22
innodb × 21
mysql-5.5 × 20
database-design × 19
aggregate × 17
t-sql × 16

Stack Exchange Network

current community

your communities

more stack exchange communities

Tag Info

New answers tagged select

How do I SELECT elements using WHERE with another table's record values in WHERE statement?

Tag Info

New answers tagged select

How do I SELECT elements using WHERE with another table's record values in WHERE statement?

Related Tags