I am learning SQL Server, and I have a sample database which I got from my co-worker. I created a stored procedure previously which works fine. Now I am trying to show average of the column which I am struggling at the moment. Your supports means a lot and I will learn from this. So here is my query: And
Tag: inner-join
How to write this SQL query more elegantly ( joining + max query )
Ok I am using the following example from w3school https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all and I want to get the date in which the amount was ordered This works but my guts tell me I need to use joining or having ?? Answer You want the date of the order that has the maximum quantity…
Query help in SQL
I have the below table, with empid, deptid, and Name. I need to get the results as empid,deptid,name and count of employees in each department. I need to get the results as empid,deptid,name, and count of employees in each department as below. I am able to achieve results using the below queries. Is it possib…
PostgreSQL – How to find the row with a record that matches it with a value higher than given value?
Let’s say I have two tables with a 1-to-many relation. Table A (user): id INT, name TEXT Table B (skill): id INT, user_id INT, skill_name TEXT, skill_level INT Each user may have multiple skills. And …
SELECT statement with where clause on Column
I am trying to gather some data from a table with INNER JOIN with another table. What I am trying to get have 2 Types and I need to separate these 2 types in 2 different columns. In table where I am Inner joining have a column called ‘Data’ and another Column called ‘Type’ depending on…
Querying a cte – The multi-part identifier could not be bound. How do I fix this so I can query the table? New to SQL accounting background
I am trying to extract a dataset which joins 3 tables Employee E AbsenceTypes AT AbsenceBalance AB In the data set I need the most recent record from AB.BalanceTime for each AB.EmployeeUID by AB….
Counting organizations which user has not contacted
I am new at PostgreSQL. I have the following tables created in my schema: User table: Organization table: And finally Organization_rating table: With this schema, an organization has a business type in which gives support to the user that also have that business type. After giving this support, the user can r…
How do you populate boolean columns based on a table of properties?
I have a table called Product that contains a product identification number and an id associated with the product identification number. pin id 11 10 12 11 13 12 I also have a property table with the …
aggregating Posts with all their Hashtags using Postgres
I have something like Posts in FB/instagram. When a user searches for something, the input query is used to either find Posts that either have this query in their content, OR – one or more of post’s hashtags match this query. The problem : I can’t figure out how to have Posts returned with a…
How to get the third level of a tree in SQL
I aim to list the forth generation of a family using SQL Server. Example family tree in the picture (id based) FAMILY TREE The tables I have are: Family +——+—————–+ | f_id | f_name …