So I have created a table in SQL I get the same result on 2 different online SQL website IDE I was given to use. https://sqliteonline.com/ and https://www.jdoodle.com/execute-sql-online/ As you can see on the select query I enter the dates that I get returned are not the ones I inserted. Am I doing something wrong?… Read More SQL DATE return not giving what i INSERTED in the Table
I am pulling data that contains two columns with dates. I only want to return rows of data where date one, last_update occurred within 7 days of date two, program_end_day. I have tried several variations of the following but this returns rows where last_update occurred years before the program_end_day and last_updated >= DATEADD(DAY, 7, program_end_day)… Read More SQL pull data based on date range
I have two tables, City and Vehicle. Now I want to merge the two tables into one table. Then count each type of vehicle based on city. Then merge them in to one table. Could someone help me? City: City_Id City_Name 1 New York 2 Washington Vehicle: Vehicle_Id Vehicle_Type City_Id 1 Electric 2 2 Fuel… Read More How to merge columns from two table structures into one table, and count group by one filed?
I have the "👍" emoji stored as a message in my database. When I execute my store procedure to retrieve records where select top 10 * from t_MemberApp_PushNotifications where contactID = 10930547 and pushMessage <> ” order by 1 desc It doesn’t display the data when only emoji is present. As you can see the… Read More Trouble retrieving emoji messages in SQL query and ignored or treated as empty string
I need to find the records with the longest field answer, for example: To get the longest First_Name, Family_Name and Company, it returns 3 different records, 1 for every longest answer and its record id. SELECT TOP 1 Id, LEN(First_Name) FROM Persons Group BY Id, LEN(First_Name) ORDER BY 2 DESC Something like this would bring… Read More SQL find multiple longest column results with its id and collect them in a single query result
I want to pass a input to sql and if the input i passed is reg_number is ‘22162’ then I filter with the mdate = ‘2023-10-20’ else I just filter with reg_number is ‘13352’ How do i check in where statement whether the input is passed is ‘22162’ and then filter on that? Please help… Read More input if match then filter query
I have 366 date IDs for the year 2024, and with these IDs I need to prepare a set of data that I need to upload into a table. This is the query for the date IDs. select date_id from hire_date where calendar_year = 2024 order by date_id the date IDs are: 5489 5490 5491… Read More SQL – Update multiple rows with a single key for multiple times
I have got a problem and I have no idea how to solve it because I’m a beginner. I have a table like this: id date time title 1 2023-03-03 2023-03-03 10:00 A 1 2023-03-03 2023-03-03 10:10 A 1 2023-03-03 2023-03-03 10:20 A 1 2023-03-03 2023-03-03 10:30 B 1 2023-03-03 2023-03-03 10:40 B 1 2023-03-03… Read More SQL How can I group rows for every id and date without duplicates in names and arrange them
For example: Select… FROM… WHERE street IN ( SELECT street, country FROM … WHERE … ); Here we have only 1 value before IN (that is "street") and the subquery have "street" and "country". My question is, can I do that kind of thing? I have a side question: Can I use MAX(…) inside WHERE… Read More Can I use less values in IN clause in SQL than the subquery contains?
I have 2 table. Payment (28 Field/Column) and Users. In the payment table there is a CreatedBy column which is taken from the Users table. Here’s the code select *, users.Userid from payment left join users on users.Userid = payment.CreatedBy where payment.PatientInvoiceID = ${id} and payment.DeletedBy is null I just need to get Name from… Read More Select SQL Duplicate Data