Posts by Lucas Esbegue • 37 points
6 posts
-
0
votes0
answers28
viewsQ: Resultset to return BD data - Java
All right, let’s go... I have a question, I have a Bd with 3 tables and used Inner Join to unite them, and internal function of Postgresql to create a dynamic table, whose result is this: I need to…
-
2
votes3
answers5148
viewsQ: Return BD data using List/Arraylist - Java
I have a problem, I set up a dynamic table in Postgresql and I need to print the lines of it, performing a method in Java, whose beginning is already pre-set. That would be with a List simple with…
-
1
votes1
answer4525
viewsQ: How to handle Null fields in Postgresql
Hello, I need to know how to best use COALESCE to treat the null fields in my table. My problem is the following, I’m simulating 6 Stores and their respective cards, let’s assume that one or more…
-
0
votes1
answer181
viewsQ: Create query to return the smallest possible value
Good night. I need to do a sales report grouped by period and by card. But I do not know how to enter a store and horizontally of it appear the values of each card. Example of how the output should…
-
0
votes0
answers170
viewsQ: How to create method to print a report - java
How do I create a way to print a DB report. Follow my method below. public void printReport (Date initialDate, Date endDate){ list<Sale> sales = getSales (initialDate, endDate); for (Sale…
-
0
votes1
answer49
viewsQ: Postgresql Database
How do I select with sum and inner join to sum an x value between 3 tables. A query to return as few results as possible. create table credit_card ( credit_card_id int primary key, nome varchar (30)…