I am working on small school database and I need some help with selecting students that are only booked on different days in week 1 and week 2. My table structure is like below: I would like to get all the children that meet the following criteria: ONLY booked in week two (This is ChildId 2 and I can get
Tag: sql
converting rows to columns using oracle sql
I’m trying to convert rows into columns using the following sample: LVL COL_VALUE TABLE_SRC 16 INT: ADDRESS_LINE_2:NULL INT 16 BASE: ADDRESS_LINE_2:X BASE 17 INT: ADDRESS_LINE_3:NULL INT 17 BASE: ADDRESS_LINE_3:X BASE The output should be: INT BASE INT: ADDRESS_LINE_2:NULL BASE: ADDRESS_LINE_2:X INT: AD…
How to fix NEXTVAL returning null in insert query but returns correct value when executed alone in PostgreSQL?
When I execute the following insert query: I get the following output: The third column which is supposed to be filled by the NEXTVAL function result is being sent null, which is violating a certain non-nullity constraint. However when I execute NEXTVAL independently like this: The function returns a correct …
Running Dlookup() on a query with row count column as criteria (MS access)
Im trying to run Dlookup to return all values of a column in a query’s results. As Dlookup can only return 1 result I have added a row count column to the query so I can use the row count as the criteria for the Dlookup. My query results look like this in the results Query design view Query results
How do I summarize sales data in SQL by month for last 24months?
I have big number of rows with sales for different products on various days. I want to retrieve the sum for each product and per month. For the last 24months. How do I write a WHERE function showing the last 24 months (based on latest date in table not actual date)? How is that summarized and shown by month i…
How can I use IF and CONCAT within SELECT
I have this Adjacency List Model table Table: Output: So I have the following query that duplicates a Site 1 e.g. and its children. In this case, the children are Paper with parent_id = 2 and ms1 with parent_id = 3 Output: As you can see Site 1 and its children got duplicated with a new unique id. However for
How to do the total sum of a group by?
I have the following table I am able to retrieve val by group with : Which give me the following output : But I don’t know how to do : Numerical example : How should I do ? Answer
Function to check if a date is a Christmas day or New Years day
I am creating a function in SQL Server to validate if given date is a Christmas day or new year’s day. Please kindly advise if following code is OK: Above is the simplest way I can think of regardless or timezone and date format Answer I would create a table-valued function like this, rather than what I…
SQL How many of a counted row is in another counted row?
I’ve been stuck on how to write a particular query for the following question: How many employees are in how many businesses? My end result should look like this: EmployeeId Count BusinessId Count 1 23473423 2 56245764 3 834456 So there are 23473423 businesses that have 1 employee, 23473423 businesses t…
Databricks error when change type column from string to numeric
I have a error like: com.databricks.backend.common.rpc.DatabricksExceptions$SQLExecutionException: org.apache.spark.sql.catalyst.parser.ParseException: no viable alternative at input ‘alter table x9concsheet5 Add netto_resultaat'(line 1, pos 29)* when i run this sql command in databricks: %sql alter tab…