I have two tables with the following data: Table 1: Table 2: Then I used a join for this Table 3: I need to get the row with 101 – 204 – A and 102 – 213 – A. Data is available in Table 1 but has no data aligned in Table 2. Is there a way to get this?
Tag: sql
Get rows within current month
Get the rows from a table filtered by current month in psql. Example table – After query result, assuming current month is July, 2020: Answer The usual approach is to use a range query to allow for an index usage on registration_date
SQL sum values in columns for each row
I have the following table: how do I sum the values of say, column 2 and 3, to return the sum? The expected result is: Answer You can do maths within a select statement, so the following will work:
additional condition in a SQL query with min(Date)
I have the code presented below provided to me by one of the members but I do not understand how it acts: The code extracts the min of start from another table. I wanna add an aditional condition like: I cannot insert the condition without an error. Also, I need only to see min(pr.”AsigStart”) fro…
SQL query to get the output
I have two tables Table A and Table B as listed below. What is the SQL query to get the below output? Answer This looks like a cross join, to generate all possible combinations of rows between the two tables. Assuming a structure like tablea(col), tableb(col): If you want to concatenate the results in a singe…
How to transform my existing table into this specific format using T-SQL?
I am using SQL Server 2014. I have a table T1 (extract shown below): I would like to have the following output using a T-SQL query: The logic here is that data related to a specific ProfileID is to be transformed into the wide format. The StayID column is always unique. I have been looking into the pivot func…
sql; concatenate MIN(price) and MAX(price) into column?
I am working on an aws athena query like so: Which will give results like so: Right now I have maxprice and minprice as two separate columns, but I want to combine them into one column “price range” which will have minprice and maxprice separated by a ” – ” string, so it would lo…
aws athena SQL query; get unique count of column2 for each unique column1
I am fairly new to SQL queries, and am working with querying an aws athena database. My first query will return every unique brand given some parameters: Returning a list like this: And so on and so on for 553 rows. If I pick any of the brands, such as ‘Seraz’ and run this second query, it will re…
Window functions in SQL: why are they called window functions?
I understand window function but don’t understand why they are called window functions. When we say the “window” is it both the partition and the order by clauses? Answer Window functions operate on a range of rows, defined by the OVER clause. It is like you are looking through the window, y…
JPA Criteria Builder query with inner SELECT statement
I need to create the below SQL join condition using JPA criteria builder, Below is the entity class and JPA query builder. I am able to build the query with join condition but cannot create the inner SELECT query. How can i create a inner select query for join clause? Requirement description: The below is the…