Something very unusual happened in my bank. Some records have been entered more than once (7-13) to be more accurate. This was due to a software error that has already been resolved.
Now I need to delete duplicate records, but I have the foll...
I made a select command on my table estoque where I bring the supply model , your current quantity and what your quantity minima in the inventory, for this I made query as follows:
SELECT codigosuprimento, suprimento,...
I'm having a hard time. In the query below, you're bringing it that way.
Tarefa_Inclusao Tarefa
167909 167920
SELECT TarIDInclusao [Tarefa_Inclusao],tarid [Tarefa] FROM Tarefa WHERE TarID = 167920.
In this query is a...
I'm trying to create a query criteria selection engine. For example:
I have a mass of data where you have the following variables:
store code
Brazilian state where you are
Brazilian region you are in
Flag of products that the store...
Well, as a beginner in SQL, I need some help. I need only bring records that have not been moved for more than two days.
The query below is bringing everyone without this condition. I even did a test using the datediff, but I'm not sure if th...
Greetings to everyone in the community. I'm going through a strange problem. When I select the syntax of the query and colon in PHPMyAdmin, the query returns all the fields I want. But when I put it in the code, it does not return any value....
The title may not represent the issue well.
I have a table with information about cars (id (CP), name, model, among others) and another one with the "Extras" (id (CP), car_id (CS) p>
+---------------------+
| tbl_carros |...
Good morning!
Well, how do I perform the correction of data accents from a select in the sql server. For some records that were meant to come as Sergio, Sergio is coming.
At the end of index.php (responsive layout) you have a call to
< script type='text/javascript' src='desk.js'>< /script>
It turns out that this JS will only act with MediaQuery greater than 1024px.
I ask:
Is it possible to m...
Does anyone know how I could list the last message of each user?
I was able to do this but list the last message of only one user, and I wanted it to list everyone who sent the message to the user in question (code 3).
SELECT m1.codigo,...