I write SQL load testing tool where user could just specify the number of conditions in WHERE section (and some more functionality) using sliders, then press button “Start” for starting load testing of database. The problem is: If I use OR logical operator for joining clauses, the DBMS would stop …
SQL Server check for prior record only
I have these columns: type(char), date , price. I would like to check if the same type’s price has not changed in the previous record. I tried this for start: I only want to check for the date prior not for every date that is smaller. This table stores price changes. product_type change_date price ̵…
Use SQL to select one id that correspond to two indexing words in two rows
I’m trying to select the ids that have indices “a” and “b” by joining 3 tables, then using WHERE to select the rows I need. The three tables have roughly the following schema: I joined the 3 tables on id. Table 3 has a one-to-many relationship, where 1 id corresponds to multiple …
sum values based on 7-day cycle in SQL Oracle
I have dates and some value, I would like to sum values within 7-day cycle starting from the first date. this is my input data with 4 groups to see what groups will create the 7-day cycle. It should start with first date and sum all values within 7 days after first date included. then start a new group with
How to show the most recent value for each row [closed]
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 1 year ago. Improve this question This is my current query. I used an inline view to only show the top 5 results for the compan…
How to Loop department names
Oracle SQL Developer I want to Loop department id and department names starting from dep_id = 10 and till 50th department. Departments are increasing by 10, so, there are 5 departments from 10 to 50. Here’s my code And here is the output, But as you can see the Administration row is repeating itself. Th…
Is there a way to change the output row name in Oracle?
I have Procedure which removed/deleted the lowest lnr. The code works fine. So my question is, if there is anyway I can make my output better. I’ve tried following: But it doesn’t work like it does in SSMS. I would like to have output such as: Answer You could simply add a column for status
query range on column [closed]
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 1 year ago. Improve this question I need help on query where I can do the range query based on Name Column from names. e.g., as…
Dropdown selection based on other dropdown [closed]
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 1 year ago. Improve this question I am working on a webform that will allow the user to simulate a purchase of a movie ticket. …
SQL code does not work when converted to JPQL code (ORA-00904 error code)
Thank you very much for looking at this post :). I have the following problem: I have a piece of SQL code that runs perfectly on the Oracle database. The problem comes when I try to run as JPQL code. I get the following error in the Eclipse IDE: Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904:…