Create a select where the name and last name of the employee, department where he works and the name and surname of the manager who coordinates it.
SELECT EMPLOYEES.FIRST_NAME||' '||EMPLOYEES.LAST_NAME AS "NOMBRE COMPLETO DEL EMPLEADO",DEPARTM...
Well I have the following error, that when I try to register data in the database I get the following error
Error: SQLSTATE [42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresp...
I need to delete a record from a relational table, the data is in the main table, as I show in the image.
for this I have the following query that runs without error but does not affect the records:
DELETE FROM usuario
WHERE EXISTS (DELE...
First of all explain that I am new in this world and try to learn based on trial and error ... to start, I am creating a login against my database using asynchronous connections with ajax where you can access through different users created by a...
I was working with a web that I'm doing, it has a kind of login and this error appeared, I redirect them with header.
This page does not work
The mivhost.com page has redirected you too many times.
Delete cookies
ERR_TOO_MANY_REDIRECTS
<...
I have a table (Users) with 2 rows
nameUser como varchar(50)
passUser como varbinary(200)
The question is that I am entering test data for later processing but I have noticed that entering the same password gives different encryption, for e...
Good, I tried to make a query to delete all the tickets that do not have details, but it gives me an error of sql syntax.
DELETE FROM ticket t JOIN ticketdetail td ON t.id = td.idticket WHERE
(SELECT count(*) FROM td JOIN t ON t.id = td.idtic...
Good day friends I have a doubt to the I do the following query
As a result I get this
Is there any way to bring the data in the order in which the query was made? That is first the data of Id 1, then those of 3, and finally those of...
How to consult from the current system date without having to specify the following
fechaEntrada BETWEEN CONVERT(DATETIME, '2017-11-01 00:00:00',121) and
CONVERT(DATETIME,'2017-11-01 23:59:59',121
The query:
select c...
I have the following concern:
When making this query
SELECT * FROM la_tabla ORDER BY padre
row 4 should be located below row 1, however I am getting this result, what is the error here?