I am having table like this, where id is repeating several times. I need to get only max L1 value for each ID, so correct result from the que
I wonder how this query is executing successfully. As we know 'having' clause execute before the select one then here how alias name used in 'select' statement
I have a database like this and it goes on for like 2.7m more lines. Is there an SQL condition where I can remove the identifier from the titleurl in the whole
This is the query I have so far, which returns the customers of a user. But I need it to also return the children of these clients. SELECT c.id_client, c.uuid,
I'm trying to delete rows from table using delete. delete a from "table1" as a LEFT JOIN "table2" AS b on a."x" = b."x" where b."X" = 'X' but everything I ge
I am dealing with the following JSON in a Postgres database column called steps in a table called tCampaign : [ { "name":"Step 1", "stepRefe
I am trying to use a GROUP BY statement that would count each of the progress grades: SELECT with_avg.*, CASE when T_Points = Average then 'On Target' when T_P
in relation with how to copy the records from output of oracle SQL developer to excel sheet I'm using Oracle SQL developer. I've some queries which get some nul
I need help with a select in postgres, I need to group X types into a single line, for example: type: multiple, trully, I need help on the type column SELECT tb
I'm new in Hibernate. I can't understand how Hibernate process ? in Restrictions.sqlRestriction() method. For example, there is a sample from
My getByTitle query doesnt seem to work, all my other routes and models work perfectly using params. Not sure what it is I've written wrong? For context this is
If I write "select Tags from Posts WHERE Tags IS NOT NULL" on site https://data.stackexchange.com I can only download 50,000 rows. How can I get all rows?
The input I have is composed of the following columns: time, UseID, and value. I want to get the plt column as the product of successive numbers. I know about t
I want to Create a table @tablename with data from a User-Defined Table Type but I get the error Must declare the table variable "@tablename" ALTER PROCEDURE
Can we convert Dataview Sent/Open CST date to UTC timezone without using dateadd funtion. Any other timezone related function?
I know there are tons of question that includes that error, but I haven't seen one that incldues a subquery with row_numbers. Ok so I have this raw query which
I am using Laravel 8 and MySQL8. I have these tables: products id - integer name - string factories id - integer name - string factory_product
I have been applying for Junior DEV roles and encountered a problem on a Codility take home test that I aced... except for this question. Which I bombed. I have
I want to create a database trigger that deletes automatically rows where the value of happened_at field is older than 15 days. My table rows id int(11) site_id
In AWS Athena, I am trying to join two tables in the db using the date, but one of the tables (table2) is not clean, and contains values that are not dates, as