Tag: sql

Mode average – need help for calculation in SQL Server

I need to calculate the mode average by clinic. Test data as follows: Clinic Test2 A123 2 A123 3 A123 4 A123 3 A123 3 B123 2 B123 2 B123 2 B123 2 B123 2 B123 4 I can show the mode for all clinics using However, I want the mode per clinic, not all clinics. What I really want

Insert a line with different values

database mysql sql

How to insert a line ? position the number 12 piece_color the R id 0 and 1 . I want to have two numbers here I did The returned error was: Answer You need to specify the columns to insert if you would like to use VALUES. In your case, it would be something like this:

HR SCHEMA: the year of most employees hires [closed]

oracle sql

Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed last year. Improve this question IN the HR Schema in oracle how do I get the year in which the most employees were hired? Answe…

How have you set up your database? Do you have to change a lot with a new year? [closed]

database mysql php sql

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed last year. Improve this question I have a question about databases. What does your database actually loo…

store sql queries as string in node server to get them as a response(express)

express node.js rest sql

I am trying to do something may or may not be possible. I have a SQL file called “travel.sql” that I am trying to make an api out of, so I thought the simplest thing to do is to save the queries as strings in an array and then save the array of strings as a response for a node

Polymorphic association query multiple JOIN as separate columns

polymorphic-associations sql

I’m trying to extract a query that needs to access a polymorphic association table in SQL twice (I need to JOIN it on both ‘types’) Here is the structure for the SQL tables. I want to query each individual answer from the ‘Answer’ table, inner join with ‘User’ table o…

How to select all parents of a child from a table

sql sql-server

I am using SQL Server. My table is called Employees. It looks like this: I am trying to build a query that returns all parents of the children So the query would return the parents of Bin and Sam are I tried this but wasn’t successful but this can only work for 1 parent How can I get the whole

Query SQL Server From Specific Time On Previous Date To Specific Time On Current Date

date-arithmetic datetime sql sql-server

Sorry for the noob SQL question. I have a table in SQL with a DateTime column. I need to run a script daily to show any lines from 8am yesterday until 8am today. So for example, today I would run: I also know that I could run this, but this will only give me the previous day through the current

Getting previous month data not working in sql server

sql tsql

I am trying to get the previous month data according to the datetime in the column dynamically for example I have data like this Now I want the records previous than Opendt. The problem is that I am getting the record after Opendt but I am getting empty when I am getting the record before 1 month or 2 month