Is there an efficient way to add the Instance and Instances columns on sorted SQL? Some kind of self join? I quite often have to do something like this and loop
I have 2 tables, one main table and one audit table. create sequence dbo.users_seq; create table dbo.users ( id bigint primary key default(next value for dbo.
I have a data set of students that calculates average scores (to the nearest decimal) as of a certain date.The data set is riddled with typos. A sample data is:
I want to format the strings in a table column, in a specific format. Input table: file_paths my-file-path/wefw/wefw/2022-03-20 my-file-path/wefw/2022-01-02 my-
I've got no idea why is this happening. I thought the "JOIN FETCH" thing and/or "EntityGraph" were meant to address this, but then the query made by Hibernate l
I'm looking for a way to best analyse the user data in our app. for example how many users have read 0 articles on our site how many users have read 1 article o
I am looking to perform a query that will calculate the product revenue percentage difference from 2019 to 2020 for each state. Can anyone lead me in the right
We have worked with Oracle for a number of years and we now need to develop a new application using SQL Server in AWS for the first time. What surprised us, is
I tried to code A own function that adds the values (NumberStars) together and then calculates an average value from th NUmberStars. Numberstar is a value that
I am new to databases and SQL and I am stuck with this problem. Any help would be apriciated. Thank you in advance. I have the following schema: The problem is
I would like to ask for help :) Two INSERT statements are issued simultaneously by 2 users into a doctrine-generated many-to-many table: INSERT INTO my_table (c
I have a tree structure that looks like this: root A B A
Display id, name, manager id and manager name of those employees who are allocated a computer and whose manager is also allocated a computer. Also display the m
I tried to calculate the difference between dates in months for a huge database, using dbplyr package which sends my codes to the sql query. I tried different w
I am struggling with query logic. I have two tables, e.g. Table1: A B 0 1 0 2 1 1 1 2 Table2: A B C 0 0 a 0 1 b 0 2 c 1 0 d 1 0 e 1 1 f 1 2 g I need to left
I am trying to figure out where my query is failing on a where clause, I hope some of the local experts could point it out and explain why. Also I would like to
I am trying to write an sql command that enters a password inside a string. The database entry that I need changed is in the users table preferences column and
I have two tables city and house (foreign key to house), I need get result true if city's all houses has property has_door = true.
I have a table in the following format Name|Token| Date | --------------------- John|7 |2010-4-30| John|7 |2011-4-30| John|9 |2011-5-30| John|9 |
I'm working on Odata V4 and want to use groupby clause to get data from OData svc API.But its not working .getting below error HTTP/1.1 400 BadRequest Content-