Questions tagged as 'sql'

Tagged questions
1
answer

Error loading data with AJAX

Every time I give the button to load the AJAX, I load the start screen with everything (header, menu and footer) apart from not loading the data from the table I request. I get this error in the console: [Deprecation] Synchronous XMLHttpRequest...
asked by 18.11.2017 / 19:47
1
answer

INNER JOIN in SQL with 4 tables

I try to do INNER JOIN in SQL with 4 tables, but, it does not work out. I use this SQL Query (this works): SELECT PELICULAS.*, companias.nombre AS nombreCompania FROM companias INNER JOIN peliculas ON companias.id_compania = peliculas.id_co...
asked by 18.11.2017 / 22:30
2
answers

Oracle query tabular form

start in database and I have a question, suppose I have a table called WORLD that has the following values: I want to get the following result: Could you please support me as to how this consultation would be carried out, thank...
asked by 10.02.2018 / 01:12
1
answer

Add the total hours worked during 1 month

How can I add the hours in a period of 1 month, starting from an Initial date and a Final date in such a way that the result is as follows: Code fechaActual idClave nombre HorasTotalesMes 2300 2017-12 14290...
asked by 20.12.2017 / 20:23
1
answer

Save a numeric value separated by commas in a variable sql server 2008

Greetings to all, I would like to know if any of you have used any method that allows you to store a numerical string separated by commas and then save it in a variable to be used later. In the following example, what I am trying to do is tha...
asked by 21.12.2017 / 21:03
1
answer

Add a column several times with different conditions

I am working on postgres and I would like you to help me add a column several times with different conditions for example I have my column days that are arrears of credits and the capital column that generates a credit, I need to group them as t...
asked by 21.12.2017 / 13:07
2
answers

SQL query followers

Good! I have two tables ( users and relationship ) and I want to show the followers (users that I follow, but they do not). At the moment I only have to show me the users that I follow and they also show me. Query (Users that follow):...
asked by 19.12.2017 / 17:35
2
answers

how to fill a jtable from sql

I have a graphical interface that includes a jtable, at the time of registering, it runs normally, only in the jtable it shows me what I have registered repeatedly but in the database it is registered only once. Is there a way to fix it so th...
asked by 19.12.2017 / 21:28
1
answer

sql query with conditions

trying to solve a request from a client I ran into a problem and wanted to know if it is possible to make an sql query with conditionals. My problem is the following at the moment I have a query that allows me to bring information from 3 tabl...
asked by 19.10.2017 / 18:11
2
answers

json vs jsonb postgresql

What is the difference between json and jsonb ? The @EmilioPlatzer user gave me an answer to another question where he uses these 2, but I do not see the difference. In fact, the user comments on the following:    json...
asked by 30.04.2017 / 18:13