Questions tagged as 'condiciones'

Tagged questions
1
answer

TALEND UPDATE FILA

Good, I am updating a database from a .txt file, specifically I am updating the following values. With the tmap I make the corresponding relation between the data of the .txt and the attributes of the database and then I do the update i...
asked by 17.03.2016 / 09:26
0
answers

Concatenate results of last numFile (id) registered and another update field

I need to know how to concatenate results obtained after a insert and update a field, with the information ... The insert, the isset and others work correctly, all I want to do is after if ($result > 0) . In $query2 I'm...
asked by 04.01.2019 / 19:08
0
answers

How do I extract values from one data frame to another data frame using loops and conditions?

I want to create a data frame by extracting certain values from another data frame, for what I did was create 2 matrices de 875 obs and% loop with certain conditions: Finally, what I want is to extract the value of variable X2 when...
asked by 22.08.2018 / 04:52
2
answers

Make an Insert if there is no value in a column, but make an update

Hi, I wanted to tell you that I want to do an Insert but check if there is a value in a column of the table before doing it, if it is an update only in the value of the column of the same. I pass the code to you as I have it: if(in_array($t...
asked by 28.09.2017 / 05:36
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

How to calculate how many items are associated with an ID

I'm working on excel and in one of the formulas I have to do, I calculate how many different items are associated with a specific ID. I have the following columns ID Item OPX-0020433077 Continuity Services OPX-0020433077...
asked by 04.12.2018 / 15:21
1
answer

Execute AND statement dependent on a value of a variable

In a stored procedure I want to add an AND statement to the query depending on the value of a variable. DECLARE @name as varchar(50) SET @name = '' SELECT * FROM Tabla T WHERE T.campo = 'valor' Here I would like to add an AND statement to t...
asked by 18.12.2017 / 19:25
1
answer

Help with CASE in SQL Query

First I will clarify a point that this question is similar to the one previously formulated, entering the following link you can see: Case in sql query But given that that question could not solve my doubt, after of course having reviewe...
asked by 20.03.2018 / 18:45
1
answer

How to print all the divisible numbers of a number entered by keyboard? Java For

Hello, good, I'm doing a program where I must perform the division of two numbers and if it evaluates if the first number is divisible by the divisor, if so, print all the divisible divisible numbers. So far I did odd and even numbers, but it on...
asked by 02.12.2018 / 02:17
1
answer

Repeat random number

How could you make a condition that shows you a certain message after a certain random number is repeated 7 times? For example: var gana = localStorage.getItem('j1'); if (gana == c) { alert("Gana jug1"); } I have that code that...
asked by 31.10.2018 / 20:38