The query-refactor tag has no wiki summary.
9
votes
3answers
332 views
Are these two queries logically equivalent?
Are these two queries logically equivalent?
DECLARE @DateTime DATETIME = GETDATE()
Query 1
SELECT *
FROM MyTable
WHERE Datediff(DAY, LogInsertTime, @DateTime) > 7
Query 2
SELECT *
FROM ...
7
votes
2answers
172 views
Is there way to join every row of TableA to a row of the smaller TableB by repeating TableB however many times are needed?
Sorry for the confusing title, I wasn't sure what to write there.
I have a table of a few hundred records. I need to assign each record of this table to a much smaller dynamic table of users, and the ...
5
votes
2answers
96 views
Fetch the newest row grouped by a column in MySQL
My problem seems like it should have a much simpler solution than what I have come up with. Starting with this data set:
log_table
+--------+-----------+------------------+---------+
| log_id | ...
3
votes
2answers
783 views
Is there a more concise way to convert a UTC datetime into a local date only?
I am trying to write a query that groups records based on the local date part only of a UTC datetime field.
For example, if my table contains 10/19/2012 2:00:00, then it should get grouped as ...
3
votes
4answers
568 views
Optimize Query with Derived Table
I have the following query
select
ps.id, ps.title
, IFNULL(s.likes,0) as num_likes
, IFNULL(s.comments,0) as num_comments
, IFNULL(s.ratings,0) as num_ratings
, IFNULL(s.views,0) as num_views
, ...
2
votes
3answers
649 views
Alternative query to this (avoid DISTINCT)
Note: I work with MSSQL 2008, but I guess it's valid for many others DB engines
I have this table "Users":
UserID User CountryID
1 user 1 1
2 user 2 2
3 user 3 3
4 user ...
2
votes
1answer
46 views
Query difference with where condition
I need to find the ids of all rows in a table A without a matching row on table B. Following the answer on this question I'm using a left join like this:
select A.id from A left join B on B.id_A = ...
1
vote
1answer
207 views
This refactoring from cursor on a dblink'ed Oracle table OK?
The data is being compared from the local version of the table to one in the contracts linked server. I'm not certain what the goal of this code is in the first place, but I'm trying to get a handle ...
1
vote
1answer
116 views
Is my case statement broken by the use of outer apply?
I'm struggling with a case statement not working. Simple enough I need to supply a value of 0 where the question marks are. I have several other case statements which handle separate columns, but this ...
0
votes
1answer
80 views
How can I optimize this query and support multiple SKUs?
My current query only can select one SKU at a time. I can leave salesite_id constant. If there is a way to also have varying salesite_ids that would be good too, but not necessary. Also any ...
