Problem is that i get a whole bunch of users, that does not match the search string no matter what i search. And it seems like there is baseline of users that is allways passed. I cant figure out what exactly it is finding, but the lenght of the return of users vary depending on… Read More SQL search many conditions must return one row

i have recently started exploring DataBases. i cant solve a task: i have a class that makes changes in my DataBase(sqlite3). i dont know how to close correctly db connection. i thought and find a decission. is this optimal and correct? class DBConnection: def __enter__(self): self.conn = sqlite3.connect(‘main.db’) self.cursor = self.conn.cursor() return self.cursor def __exit__(self):… Read More How to close database sqlite3 in class?

I’m working on a weird query that might need a filter inside a having clause but since I’m not including the column that I’m trying to filter in the having clause in the group by it does not work. Wondering if it can be done in any other way in the sql itself? TIA For… Read More Right way to filter inside a having clause

I have a following sample table structure Name Address Name1 Address1 Name2 Address2 I need to get the Name1 but my search criteria is longer than the column value. Sample query SELECT * FROM SampleTable WHERE Name = ‘Name1Me’ I have tried truncating the search criteria until I get a match like below SELECT *… Read More SQL Query needed if search criteria is longer than column value

Consider the table ID Value 1 3 2 4 3 6 4 7 5 8 6 11 7 12 I want to find rows where the difference between two subsequent Values is different than 1. Id = 2 has Value = 4 and Id = 3 has Value = 6, difference in Value between these… Read More How to find rows that have specific difference between two rows

I have two tables: Test1 and Test2. Test1: Cat Dog Date 123412 1111111 2023-01-01 12:01:01 123412 2222222 2023-01-01 13:02:01 Test2 Cat Parrot Date 123412 1412111 2023-01-01 14:01:01 123412 2242222 2023-01-01 15:02:01 The script for joining these tables looks like this: select test1.cat test2.cat from Test1 test1 left join Test2 test2 on test2.cat=test1.cat It is necessary… Read More Output data without duplicates by maximum date

So I’ve tried searching and reading through many other posts before making this one. Suppose you have two tables — table A and table B — where table B has more columns than A. Both share 2 columns: ID, location. How would you: (1) find any ID’s that overlap between the two tables (2) if… Read More Finding Overlapping Entries Between Certain Columns Of Two Tables

For every row where there is html text in a given column I need to do the following. I need to replace a string WITH whatever the strings that follow have as text. While I know that in SQL I can do something like this SELECT REPLACE(‘I like cats’, ‘cat’, ‘dog’); as I indicate, I… Read More SELECT REPLACE plus a touch of Python?

Using this hipotetical scenario (image above), what is the best way to show the name of the Children related to the Parents’ ID passed by parameter? For example: if I receive 1 as Parents’ parameter, I need to show the name for their children. In this case? Emily, Alexander and Sophia if I receive 7… Read More How to get all tuples related to one passed by parameter in SQL?

I am working with Netezza SQL. I have the following table (my_table): id fav_color date_of_entry 1 1 red 2009-01-01 2 1 blue 2010-05-05 3 1 red 2011-01-01 4 2 green 2009-02-02 5 2 red 2010-04-04 6 2 blue 2020-09-09 7 3 red 2009-05-05 8 3 blue 2009-06-06 9 3 red 2010-05-05 My Question: I want… Read More SQL: Identifying a Row Closest to a Given Date?