Questions tagged as 'query'

Tagged questions
0
answers

Node JS + MySQL

I took as skeleton the code generated by Express JS and everything works fine. The issue is that when I show my page ... / one, it shows me the right result but only for about 5 ms and the content disappears. Do you know why this happens? I woul...
asked by 22.03.2018 / 20:14
2
answers

Duplicate value ERROR, but I need to identify the field

My question is very simple but I guess we are all here to support each other and keep learning. My problem is in this line of code: INSERT INTO DEPENDIENTES VALUES (78900456,'Oscar','M',15-01-89,'Hijo'); the error bounces me...
asked by 22.10.2017 / 21:55
2
answers

Obtain a single data from two Oracle queries

I need to make a query, in which if a subquery returns a value null execute a second subquery which guarantees me to return a value the two subqueries return the same value. FIRST_VALUE (pac1.pac_name) -------------------------- |Oct/20...
asked by 27.09.2017 / 22:36
0
answers

HELP! How to make this MySQL query

I have these tables, payroll, deductions, bonuses, advances, employee, and what I want is to add the total bonus, total deductions, total advances, then show this data, and with this calculate the total salary and group it by idEmpleado, I've do...
asked by 24.04.2018 / 06:40
1
answer

Query executed in Python does not return information from my Oracle database

The problem is that I'm doing some queries to the oracle 9 database from my python 2.7 script with the help of cx_oracle but when printing the cursor values it does not return information which IF IT EXISTS in the database. I have tried pla...
asked by 25.05.2017 / 17:12
1
answer

(SQL) perform Inner Join via conditional

I am trying to make a query of three tables in my MariaDB of a gym: Clases Instructores Usuarios What the query asks me is the following:    "Know which is the class that has more students and display" class ",   "Full name of the instr...
asked by 03.05.2017 / 18:18
1
answer

SQL - Group query result in a field

I am programming a script in php and I have created the following query: SELECT t2.id_usuario, t3.nombre, to_char(t1.fichaje_fecha, 'YYYY-MM') AS mes ,SUM(CASE WHEN t1.operacion = '+' THEN t1.tiempo ELSE '00:00:00' END ) AS "positivo" ,SUM(CAS...
asked by 24.03.2017 / 17:43
0
answers

Do stored procedure with a tour of another table

Good afternoon community. I am a beginner in this of the stored procedures, and I would like to know some way to do the following: I have these 2 tables: Balances saldoid|cuentaid|deudas|abonos|mes -------+--------+------+------+---...
asked by 14.03.2017 / 00:30
1
answer

Error creating an Identity in Oracle

How about people, I hope you can help me solve this problem even if it's silly, I'm trying to create a table with an Identity type ID and I'm getting the following error: Error que empieza en la línea: 1 del comando : CREATE TABLE USUARIO ( us...
asked by 05.05.2017 / 18:54
1
answer

avoid duplicate records in query and date correction

I have two small problems with a query 1) I am conducting a search of the clients related to the logs, this query should bring me those bitacoratime logs where the code is equal to the id of the clients, the problem is that the clients should...
asked by 23.12.2016 / 01:26