I have seen many posts about this issue using joins but not for the same table. I am trying to compare the dates from different rows on the same table. I am writing tax software that tracks liens. The tax charge is on one line and any interest charged is on another. I need to compare the dates of the
Tag: sql
Finding rows in SQL where changes but only certain changes while keeping others
I have this scenario where I want each occurrence of an active row to bring back that row in my result set and also inactive if there is only 1 inactive record for that IDENTIFIER and also if there are more than 1 active also show those. I’ve used Row_Number function and then in another query show where…
sql selecting unique rows based on a specific column
I have an table like this : I am trying to filter out something like this based on Col1 I am trying to get the all unique rows based on the values in Col1. If I have duplicates in Col1, the first row should be taken. I tried SELECT Col1 FROM tblname GROUP BY Col1 and got unique Col1 but
SQL table.column not working when I use it with full join
I have this SQL query: And it returns the error : “unknown column main.cname in filed list”. while the column certainly exists: seems alright. I tried using aliases but it just made it worse. I’m clueless Answer As coyeb60297 has pointed out, MySQL doesn’t do full outer joins so your q…
SQL DATEPART(qq, @date) date quarter start October
I have a query that prints the data grouped quarter, the query uses datepart(qq,repo.lesson_date) SQL function. My issue is I want my first quarter to be October-December and not Jan-March like the output I get from the SQL function above. Is there anyone can assist? Answer You may use an additional calculati…
SELECT from table with count from another
I have 2 mysql tables I need to get all views by user, but also need to get the user role (for each view) and calculate a dynamic number of users used for every view. So, I need to get all view columns, plus the role of the user which do this request (from ViewUser), plus count of users for
Sql data vertical to horizontal and Laravel
hi iam getting data below like this but i want to display vertical to horizontal below like this how to achive this, can anybody help in this scenario, Answer Something like this will do it:
How to fill missing values in aggregate-by-time function
I have function (from this question) which groups values by every 5 minutes and calculate min/avg/max: However, due to missing values, some five-minute periods are skipped, making the timeline inconsistent. How to make it so that in the absence of data for a certain period, the value of max / avg / min become…
SQL Query for the player and vsplayer [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed last year. Improve this question Team Table Expected Output: with Two columns How to write a sql query to get the exact output …
Retrive data of last month using Python with source as MYSQL
I am getting an error while retrieving data of the last month using python. What is the best approach for the given piece of code? I am not able to get solution, What changes can I do. I am using MYSQL as my source database and Python 3.7.4 as my programming language. Since error is big, posting it in two