Questions tagged as 'sql'

Tagged questions
0
answers

Filter By Dates in SQL

I have a somewhat confusing problem. First: I want to know how many days of payment correspond to a person according to their assistance within the current period. Table usuarios : id Nombre fecha_ingreso 1 Juan 01-01-2018...
asked by 16.08.2018 / 18:21
2
answers

Remove zeros from a string in SQL server

I'm normalizing a field that is for phones, a custom function is used, the phones should be with 8 caraceteres, but it is left with 12 and the last 4 are 0 (zeros) Example: input format = ["11232323230000"] output format (applied function) = 23...
asked by 10.07.2018 / 01:37
3
answers

Add by rows in SQL [closed]

I'm a bit new to SQL and I have a data frame like the following but bigger and I want to add some of the values in the column attributos per row and save the result in a column that already exists called Gtb . Try the following...
asked by 09.07.2018 / 21:22
1
answer

Get the last average monthly price of each product

I want to obtain from each product the average price of the last month that each product was sold. A problem is generated in the second temporary table "price_avg" because when you change the calculation from avg (punitdolar) to price_ultimoUSD...
asked by 04.07.2018 / 21:41
1
answer

I have a problem with my edit button

I already have everything, I just need the edit button but it is not edited, I pass the HTML and the php. <?php include('php/registrar.php'); if (isset($_GET['edit'])) { $id=$_GET['edit']; $editar_estado=true; $r...
asked by 04.07.2018 / 22:02
1
answer

Two submit to Edit and Insert in the same Form

This is my form: <form name='form_update' method='post' id="registerUser" action='update.php'> <input type='text' class='form-control' name='nombre' value=<?=$nombre; ?> /> <input type='text' class='form-control' name='ne...
asked by 13.07.2018 / 20:35
2
answers

Problem with LOOP PL / SQL, Oracle [closed]

I am currently working on a query with PL / SQL which I have not been able to do, the idea of this query is to be able to traverse (or compare) the rows of a table given the upper and lower limits of the table, that is, for example: there is a t...
asked by 09.08.2018 / 17:54
1
answer

SQLite query

When I want to ask a question, the program closes. I attach the code: public void consulta (View v){ AdminSQLiteOpenHelper admin= new AdminSQLiteOpenHelper(this, "administracion", null, 1); SQLiteDatabase BaseDeDatos=admin.getW...
asked by 14.06.2018 / 01:36
0
answers

SQLQuery add different columns of the same table and group them by dates

Someone who can help me with this query please. I have DIFFERENT dates and units in the same Table. I would like to add them and group them by date. Example. Queries SELECT T0.PRODUCTO AS 'Producto' ,CONVERT(VARCHAR(12), T0.[DFEC_DEV1] ,...
asked by 26.06.2018 / 04:02
0
answers

Capture data from an html table with jquery and send it to a servlet

Dear, please request your support to solve a problem. I'm working on an application and I need to see how to capture the data from an html table with records that comes from another table with records but I can not do it since both tables are in...
asked by 11.07.2018 / 16:04