Questions tagged as 'sql'

Tagged questions
2
answers

Find a data from a table and place that data in another ORACLE

I have a table in an Oracle database called temporary CREATE TABLE temporal( Nombre varchar(50), Tipo varchar(50), Pais varchar(50) ) ------Datos------ ---------------------------------- Nombre | Tipo | Pais -----------------------...
asked by 03.01.2019 / 08:02
1
answer

How to join these 2 ORACLE queries?

I am implementing 2 queries which have very common in contrast to one that makes a filter First query: SELECT FECHA, sum( case org_account when 'OtaDMC' then...
asked by 12.12.2018 / 16:31
4
answers

Pivoter table in SP Sql Server

I have a case where I have to pivot a temp table that I use in SP, this table must have a format by Number of Month example: My sp executes the following :, but to achieve the above, a pivot is necessary, but I have sincerely trie...
asked by 17.04.2016 / 02:47
2
answers

customize exception - exceptions management VB.NET

I am making an application that uploads an excel file to the server through a input fileupload , when the file is uploaded, the fields of the excel file are inserted into a DB. When there are fields that have already been loaded (duplic...
asked by 15.04.2016 / 22:43
1
answer

How to create a personalized query using JPA?

I am migrating a Java Swing application to JavaFX and please if someone could help me to the following: Use PostgreSQL database. In native SQL I have this query that works perfect: SELECT count(t.idremision) as entregados, COUNT(*)-cou...
asked by 10.12.2018 / 13:00
0
answers

How could I reuse my table photo in database?

I have a theme table, which can have several photos, and I also have my publication table and can also have photos, how could I reuse my table photos, to use it in the publication table? .thanks in advance     
asked by 16.12.2018 / 01:10
2
answers

Add values of a column

people .. I have this table: What I want is to add all the values in the TOTAL column and be able to show them where it says subtotal .. can anyone help me with the formula I would have to do to show that? then the rest of the items is...
asked by 05.12.2018 / 02:36
1
answer

Update by clicking on the button

Again, sorry for the inconvenience, but I need to finish this job, and this would be the last thing. What I need is that, when you click on the update button, this sql statement is executed so that the total of the table is updated:...
asked by 05.12.2018 / 04:46
0
answers

Result value indicates how many records you have to return the left join query SQL [closed]

Hello good day I want to ask the following question I want the result value will indicate how many records you have to return the query of the left join I have the query: SELECT * FROM ( SELECT '001' AS CLAVE2, 'MOV1' AS MOV UNION ALL...
asked by 01.12.2018 / 03:44
2
answers

Error in SQL statement with Count Distinct

I'm trying to perform a SQL query to a database to get the number of pieces, for each position-phase and I used the following query: SELECT maquina AS PUESTO, fase AS FASE, COUNT(DISTINCT pieza) AS PIEZAS FROM tabla1 LEFT JOIN tab...
asked by 30.11.2018 / 11:36