Questions tagged as 'sql'

Tagged questions
0
answers

Export sql server records to several excel files

I have problems exporting records in several excel files, due to the maximum restriction of excel, I can only export 1,048,576 rows, I have thought to perform the division of records per year and per month, in order to reach in several tabs , bu...
asked by 09.08.2018 / 17:06
0
answers

fetch_array with 3 parameters?

I was doing a pagination to show one by one the records of a bd but to show the data with the fetch_array it only lets me put two parameters. How can I fix it? $registros = 1; //registros por página $sql = "SELECT * FROM base1"; $result = mysq...
asked by 05.08.2018 / 18:09
1
answer

How to get the percentage in SQL

The amounts that I handle to make the query are: (3427.2*100)/3716041.16 = 108427.9049953314659197012138188608776844 How to get it done that throws the percentage in whole because how will the system know that the percentage is 108% SELEC...
asked by 09.08.2018 / 18:55
0
answers

Problem when creating a database using the template of another (PostgreSQL)

I am creating a platform in java, where one of the needs is to create a new bd using the template of another existing one. For this I try to use the following query: CREATE DATABASE bd_copia WITH TEMPLATE bd_original; When executing the scr...
asked by 09.08.2018 / 21:00
0
answers

How to select at least one duplicate value of my JTable?

I try to establish a condition that determines that at least that I have selected at least one duplicate value in my JTable, the information in the JTable looks like this. I have something of this style that fills the JTable try {...
asked by 03.08.2018 / 17:36
1
answer

Consult 3 tables between dates with inner join

I consult 3 tables with range of dates, my small application is in development, in the main table or the first I have 4 records in the second I have 5 and in the third 7 records, but it turns out that it only extracts me from the tables 4 record...
asked by 03.08.2018 / 15:31
0
answers

ORACLE SQL CURSORS

We are doing a job for the university for the subject Databases One of the sections asks us to create a PROCEDURE with cursors We do not have much idea but we have tried to do it. We have 3 tables: exit, company_transport, seed with the...
asked by 12.08.2018 / 21:21
1
answer

correct use of having by [duplicate]

Hi, I wanted to know if I'm doing the right thing with the following tables NUMOBJ | IDIOMA 1 | E 1 | I 2 | E 2 | I 3 | E 3 | I table1: each object with all possible languages (2) NUMOBJ | IDIOMA 1 |...
asked by 12.08.2018 / 19:42
0
answers

UCanAccess "user does not have sufficient privileges or object not found"

I have a problem using Ucanaccess. When I try to execute the query String query="SELECT Last Name FROM Table1 WHERE Name LIKE" + name; gives me the following exception: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc ::: 4.0.4 user d...
asked by 12.08.2018 / 19:26
2
answers

how can I make a query with only the month and date in SQL

As I can do a query in the BD only taking the month and the year of a date, I was trying this but it marks that the month is not valid SELECT * FROM CL_RP_COBRANZA_TNR WHERE TO_DATE(FECHA_VENCIMIENTO,'MM/RRRR') = TO_DATE('10/2015...
asked by 07.08.2018 / 15:47