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 ...
Top 50 recent answers are included
Related Tags
select × 1020mysql × 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