What’s the easiest way to create a new Postgres scheme inside the database on the runtime and also, create the tables written inside a SQL file? This is a Spring boot application and the method receives the schema name that needs to be created for the db. Answer Although it sounds like this would be a c…
Tag: java
SQL Grammar Exception in Spring Boot H2
I’v got a problem in my Spring Boot with H2 project. I got a get method for listing elements from the SQL table and the SQL command working. In the H2 database I can execute and see the results but I …
How to optimize min and max to find highest score sum
This problem involves finding two min-max criteria filters to generate the highest score sum in a dataset. I have a dataset, with 3 columns. x, y, score, with over 1 million of rows. x y score 3.6 1.2 -5 4.2 1.2 -4 1.2 30.2 1 2.9 6.8 6 3.1 5.8 7 0.1 15.8 7 The data may or may not
Display the total amount of each products below the table
I’m using itextpdf to display the sql query I was able separate the table according to PROD_NAME, and calculate the total amount of each products by getting the sum(amt) over(partition by prod_name) as total_amt from the sql query. Now, I’ve been trying to display the total amount of each products…
Is there a algorithm to resolve credit rating?
I need to implement a logic in either Java OR SQL for the following. There are credit ratings from numbers 1 to 11. And corresponding to each rating say x, I have 3 grades, effectively :x+, x and x-. Difference between each grade is termed as a step. For example, 2 and 2- is single(1) step,2+ and 2- is double…
How to fetch all data without the “out of range” SQL Exception?
I’m extracting data from a database, and I’m getting com.microsoft.sqlserver.jdbc.SQLServerException: The index 15 is out of range. during RunTime. My connection class is executed as the following: While I understand why it’s happening, in this while loop: I don’t quite understand how …
Select sqlite android
I have a query with a condition but it is returning an empty result even though I have the data that matches these conditions. I am a beginner, so I’m not sure if this query is correct. public Cursor …
How can I get SUM result as an alias in MYSQL?
The code I wrote above results show like this. I want to know how to Sum numbers in the column ‘COUNTSVCE’. The column ‘COUNTSVCE’ is an alias of count(SVCE_DOMAIN). Rollup function might be a good solution but I can’t use it in my JAVA query so I get the result as alias. Thank y…
Get previous months first and last date
I need to query last month data from a database. So I need the first and last date of previous month to be able to make the “between” SQL query. First date starts always from 1 of course, …
SQL Get certain value form two tables and make result set multiple rows
I have two tables: I tried using the statement above but it would not work. I need the statement to return all the tables that have the word john in it. Answer You want union all: