I want to count the records in column 1 that start with 123, I need to count multiple times, with different values (123, 657, 897, ...) I have the values in column 2
- column1 | column2
- 1234567 | 123
- 5489186 | 135
- 1238756 | 548
SELE...
For an error, I have entered records in a table with the accents of the type о, о.
Normally we save the records with the correct accents. So I would like to know if there are any questions that you can apply to the table to replace those or...
Good morning,
I'm new to subqueries, I have a table that registers ip addresses of computers connected to the day, my idea is to list only the first two or a computer corresponding to an ip address I explain (table equipment)
my curr...
Good I have a simple form, I want to validate the fields are not empty and that the ID is not duplicated, but at the same time that those fields that are well entered are not deleted. I have the following code.
<script>...
Good I have a query where I have to make a select that gives me the maximum of one column depending on the maximum of another, I explain myself better with the following example
my table would be like this:
|nrocon|ordren|ordamp|
| 1 |...
I am making a query and in a field of that query I want to concatenate or extract all the data that is in another table. Is it possible to do this?
This is the query I'm doing:
SELECT r.id_resg as 'CLAVE RESGUARDO',
-- AQUI QUISIERA...
I have the following sql query that works fine.
SELECT
C.id AS id,
concat(C.apellido_paterno," ",C.apellido_materno," ",C.nombres) AS
nombre_completo,
C.agente AS agente,
G.genero AS genero
FROM cliente_tabla AS C...
Hi, I am trying to make a query INSERT from C # when I parcer I have a syntax error, but I do not see it. Could someone tell me if I can notice what it is, or what am I doing wrong?
//KyoTest
[HttpPost]
public JsonResult KyoTest(t...
I have a table called Productos in which I want to create a trigger which does not allow to delete a record when the existence of this product is greater than 0
I tried the following:
go
create trigger ProductoExistencia
on...