Questions tagged as 'sql'

Tagged questions
1
answer

How to make a primary key that is autoincrementable start from scratch?

Good afternoon friends a question about sql in particular phpmyadmin happens that I want a table or good several tables ids primary key autoincrementable start from scratch, since I have deleted everything from scratch but when inserting data pu...
asked by 28.10.2018 / 05:03
2
answers

Problems joining two sql tables and comparing if there is

I want to get a query where Cve, Name and Exist, in one table I have the catalago and in another I have the ones that exist, therefore I want to get all the catalago but with an extra field that is in 1 those that exist and in 0 those that are...
asked by 23.06.2018 / 20:23
2
answers

Query Oracle SQL HR schema, how to get a query referring to dates?

1. I want to show the employees that were hired in the month of May. select FIRST_NAME from EMPLOYEES where HIRE_DATE=????? 2.There is another query that employees ask me that do not have a commission but where I do COMMISSION_PCT = null or...
asked by 21.05.2018 / 17:35
1
answer

Calculate the average consumption

I have a table in a database: consumo pk_consumo fk_ruta fk_vehiculo fecha kms litros litrosx100 ----------------------------------------------------------------------------- 1 1 1 2018-04-25 3...
asked by 26.04.2018 / 08:58
3
answers

How to make a selection list for users of my website

I am something new in the world of programming and I have the following question in the following context: I am developing a web page where one can enter with your user account and make publications, comment on other users' publications, etc....
asked by 16.05.2018 / 00:45
1
answer

Make a count of a SQL count

Hello, I have the following query Select count(device) FROM entrada where badge = badge group by badge order by count desc; and I get a list of the times each badge has a device, what I want now is to join for example if the badge one is 5...
asked by 28.05.2018 / 18:51
1
answer

SQLite does not work

I'm trying to use sqlite, but it does not work for me. I'm just making the structure this is the code of my class conexión() : class conexion { String url = "C:\Users\Juan\Documents\NetBeansProjects\JavaApplication4\doc_sal.db";...
asked by 25.05.2018 / 15:34
2
answers

Percentage in SQL grouped by column

I have the following table structure: From which you want to take the percentage of the value that comes in the loans column grouped by number. of cuit. I have tried this but in all cases 100% comes to me SELECT cdd.NumeroI...
asked by 19.04.2018 / 17:06
1
answer

Validations within the SSIS

I currently have the following flow in an SSIS My question is, is there any way to put an OLE DB, which allows me to insert information into a table called errors if the Excel Source comes to fail, in a few words, if the Excel file does...
asked by 03.05.2018 / 01:42
1
answer

HOW TO MAKE A VARIABLE REGEXP

SELECT CONCAT(per.apellido," ",per.nombre) AS alumno,per.dni as dni,car.descripcion,per.correo , jor.descripcion as nombrej FROM persona as per INNER JOIN inscripcion as ins on ins.id_persona=per.id_persona INNER JOIN jornada as jor ON jor.id_jo...
asked by 31.03.2018 / 23:48