Questions tagged as 'sql'

Tagged questions
2
answers

Relate Data for inventory

Good afternoon I have a problem when it comes to relating data in mysql for a system that I am developing, the doubt that I have is that the company that I am working with buys its products wholesale, and sells them in the same way , but I'm loo...
asked by 26.09.2018 / 18:34
2
answers

How to get un duplicated records using join of 3 tables with different record numbers?

Hello good afternoon friends, I hope and they are well, I have a problem, I need to make a query sql of two tables both have records with one more than another, I made this query: SELECT * FROM ( TVIV056_RELSERIE INNER JOIN TVIV055_INTISE...
asked by 20.04.2018 / 18:13
1
answer

ERROR ClassNotFoundException: jdbc: mysql: // localhost: 3306 / athletes

I need urgent help, I get this error:    May 22, 2018 7:56:34 AM Windows.inscriptions   btn_guardarActionPerformed GRAVE: null   java.lang.ClassNotFoundException: jdbc: mysql: // localhost: 3306 / athletes It is a program where you regist...
asked by 22.05.2018 / 12:54
2
answers

Warning: mysql_num_rows () expects parameter 1 to be resource, boolean given in

I have a query ... I am implementing a system for a school project and everything works perfect except one part to implement subjects. I get this error: Warning: mysql_num_rows () expects parameter 1 to be resource, boolean given in C: \ xamp...
asked by 26.11.2018 / 17:38
1
answer

Insert a consecutive number in a field sorted by another field in sql 2012

Good afternoon, colleague, have the next case to see if they help me solve it, it turns out that I am working in sql server 2012 . I want you to insert a consecutive number in a field x according to a certain order example:...
asked by 22.11.2018 / 22:03
2
answers

How can I show the results of an sql query inside a modal?

I explain: I have a modal that opens by means of a tag, at the time of clicking, it does not show the results of the sql statement. I make the connection to the database in the head. I save a data from a previous query to be able to make an...
asked by 22.01.2018 / 19:56
3
answers

USE MAX and CASE at the same time SQLSERVER

Good morning, I created a simple database in SQLSERVER, which has repeated employees of different ages, plus an abbreviation to see if I was single or married. What I want is for me to show the maximum age per employee, I know it is not correct,...
asked by 16.12.2017 / 22:05
2
answers

Help with SQL server

Does anyone know why it goes like this and how to solve it? yesterday I was working normal with him but today I went to continue and he does not leave me ...     
asked by 13.11.2017 / 18:36
2
answers

Consultation with 5 union

I have a query, I have code SQL a union where I consult 5 tables, the common field is the fecha , how can I order to be ordered by the date of a table from one of those specific unions , here I leave the code SELECT...
asked by 17.11.2017 / 21:04
1
answer

Select differences between two sql tables

I need to select all the fields of the entries that have differences between two columns of two different tables. tables: wow_eu_leadder_3v3 and wow_eu_leadder_3v3_old columns to check: rating and ranking     
asked by 21.10.2017 / 16:04