the above query will return the last/previous month, however its missing 2 records from the last day of the last month (2022-04-30) due to the date including a time range: I’m currently manually pulling the dates but I want to automate this process, any help will be much obliged Answer The clearest and least error prone way to do this
Tag: sql
Oracle SQL select greatest value of the result of two different select statements
I’m running select statements in a loop with a cursor to collect data from different tables; Quick (NOT WORKING) example; What I could like is just one insert statement which insert just the biggest value of boths select statements. I’ve tried to work with greatest function in my loop but i’m running stuck. Both datatypes are the same for value1
PostgreSQL – I want to query out the latest Subscription status for every client with the date
The client can opt-in or opt-out for subscription from time to time. I need the latest Status of every client with the subscription date. If the client has opted-in at the first instance and never opted-out again, I need the first date when they opted-in. However, if the same client has opted-out after opting-in and then opted-in again, I need
find by name the id of a multi level categorie
my main problem is how can i search by name the id of a given category, let me explain , so ,in my database i have a table called product_category where is stored a 5 level categories. let’s take an example of it: id name parent_id 1 A 2 B 1 3 C 2 4 D 5 A 4 6
Get all values for the XML file in SQL
I have tried the @Name and I get all the values such as DefCurrency, IsICP etc but I don’t get the values. See my code below. Thanks in advance Answer All supported versions of Microsoft SQL Server have the nodes() and value() methods available for querying the XML data type, e.g.: Which yields the output: LABEL val DefCurrency [None] AllowAdjs
Get 2 record of a particular category based on foreignkey value in mysql query?
I have two table product and mastercategory product has columns mastercategory has columns I want to get 2 latest record of each category where is_hotcategory is true How can I get this I tried it with this: I’m getting last record of each category then getting 2nd last record of each category then with union combining both the search query
[SQL CASE WHEN]Why case when is not working when I specify two conditions at the same time?
Hi I was trying to a different version of SQL query that I was given from datacamp. The query I was provided with is I tried to tweak it thinking, “instead of setting one condition for each case scenario, let’s set two conditions at the same time by connecting the two conditions with ‘and ” My query is as below.
BigQuery – Picking latest not null value within 28 interval
I’m trying to add a column on this table and stuck for a little while ID Category 1 Date Data1 A 1 2022-05-30 21 B 2 2022-05-21 15 A 2 2022-05-02 33 A 1 2022-02-11 3 B 2 2022-05-01 19 A 1 2022-05-15 null A 1 2022-05-20 11 A 2 2022-04-20 22 to ID Category 1 Date Data1 Picked_Data A
How to not include duplicates in SQL with inner join?
I’m trying to list the customer’s name, last name, email, phone number, address, and the title of the show they are going. I am not supposed to list duplicate names of the customer, but unfortunately, if 1 customer is seeing different shows, their name appears twice. I am still getting duplicates despite using DISTINCT and GROUP BY. What should I
SQL Query Sequential Month Logins
I have the following SQL table username Month 292 10 123 12 123 1 123 2 123 4 345 6 345 7 I want to query it, to get each username’s login streak in Count of sequential Month. meaning the end result I am looking for looks like this : username Streak 292 1 123 3 345 2 How can