Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

How will we work together with SQL repetitions?

carriann

There are two tables: tab1 tab2

trans#  data    price
1   01.10.2021  500
2   01.10.2021  600
3   02.10.2021  700

seller# data
1   01.10.2021
2   01.10.2021

What' returns?

Select tab1.trans#, tab1.data, tab1.price, tab2.seller# 
from tab1 
LEFT JOIN tab2 on tab1.data = tab2.data

K
Kadyn last edited by

Always. http://sqlfiddle.com/
http://sqlfiddle.com/#!9/96c677/1 Five records will be returned records, it's coming. data=01.10.2021 and trans=1 Two records will be found (2 rows), then the same will be found for. data=01.10.2021 and trans=2 and trans=3 It'll be with null in joining, because there's no match.
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

Z

Does this form of CRUD work well with SQL Y C#?
Software Programming • c sharp sql • • zymir

2

0
Votes

2
Posts

0
Views

S

It does not work well that way of programming for the following reasonsdo not use parameters, concatener values in a string is not recommendedin methods you pass many parameters with data, when you should define entitiesYou should evaluate layer-oriented programming, I don't say they're all, but at least the data layer, could be applying the Repository PatternThe idea is that you define an entitypublic class Inventario{ public int codigo {get;set;} public string producto {get;set;} public int cantidad{get;set;} //resto propiedades } then in the inventory repositorypublic class InventarioRepository{ public void Crear(Inventario entity) { using (SqlConnection conn = new SqlConnection("connection string")) { string sql = @"INSERT INTO NombreTabla (codigo, producto, cantidad, ...) VALUES (@codigo, @producto, @cantidad, ...)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@codigo", entity.codigo); cmd.Parameters.AddWithValue("@producto", entity.codigo); cmd.Parameters.AddWithValue("@cantidad", entity.codigo); //resto cmd.ExecuteNonQuery(); } } }
T

Reset of repetitive lines (select)
Software Programming • sql server sql • • terrea

2

0
Votes

2
Posts

0
Views

Y

select calls_id, min(rang) from [table] group by calls_id having calls_id = [xxxxxxxx]
SQL Find a staff member who worked in the office, whose location matches their address.
Software Programming • mysql sql postgresql database • • Alberto

2

0
Votes

2
Posts

0
Views

E

That's my problem.SELECT * FROM emp WHERE emp.id IN (SELECT id_emp FROM departament) and emp.address IN (SELECT location FROM departament)
S

Will this form of interview work?
Software Programming • html form • • Saumya

2

0
Votes

2
Posts

0
Views

T

That's right.You're gonna kill the answer and you're gonna burn it.Next comes AJAX call /ajax/interviews And with him, your answer is delivered.JSON returns to an object with percentage data for each response.So it's the right thing to say to you, the form of a worker.Well, if you need an affair, then... that's what's going on inside. /ajax/interviewsWhether it really takes into account and gives a real answer or a fake, we can't find out. ♪ ♪
C

Validate DNI, CIF and NIE (Spain) in MYSQL?
Software Programming • mysql sql • • chanisef

2

0
Votes

2
Posts

0
Views

A

In the end, searching and unsuccessful I could find a solution a problem that I had recently. It turns out that the way to work with regular expressions is different from that of Mysql to that of Oracle and that is why it had conflict. The version of Mysql (See 15.1 Distrib 10.4.18-MariaDB) that I have allows REGEXP but not REGEXP_LIKE (a penalty), but equally, as I have seen it allows me to compare regular expressions in one line the only thing I have added is an OR and another regular expression, for example in a DNI. For example, validate that column to allow CIF, DNI and NIE. I have the following code of a database of an exercise that sent me after this:SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; -- -- Base de datos: reservas_programacion -- -- Estructura de tabla para la tabla reservas_vip CREATE TABLE reservas_vip ( numReserva int(31) PRIMARY KEY NOT NULL CHECK (numReserva > 0), dniCliente varchar(9) NOT NULL CHECK ( dniCliente REGEXP '^[0-9]{8}[TRWAGMYFPDXBNJZSQVHLCKE]' OR dniCliente REGEXP'^[KLMXYZ][0-9]{7}[TRWAGMYFPDXBNJZSQVHLCKE]' OR dniCliente REGEXP '^[TRWAGMYFPDXBNJZSQVHLCKE]{1}[0-9]{8}' ), nombreHotel varchar(50) NOT NULL, destinoReserva varchar(50) NOT NULL, extrasReserva varchar(255) NOT NULL, precioReserva double NOT NULL CHECK (precioReserva > 0) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; What I have explained above I do for example in the dniCliente column, validate if it is NIF, CIF or NIE (3 in 1). What I couldn't do is give names to the restrictions, I have to investigate more that.I'm waiting for someone to help.
K

How to make SQL a request that will be sorted only according to the data received
Software Programming • sql wpf • • Kadyn

2

0
Votes

2
Posts

0
Views

Create a vocabulary in the programme where the keys will be the fields of your table and the textbox values.codeDictionary<string, TextBox> dict = new Dictionary<string, TextBox>() { { @"FName", this.tbFName }, { @"LName", this.tbLName }, { @"Text", this.tbText } } The WHERE section of its request will be selected as a separate function in which this dictionary will take placecode:private string getWhere() { string tmp = @"WHERE "; string result = string.Empty; foreach (var next in dict) { if (!string.IsNullOrWhiteSpace(next.Value.Text)) { if (result != string.Empty) { result = result + @" and "; } result = result + string.Format("{0} = \'{1}\'", next.Key, next.Value.Text); } } if (result != string.Empty) { result = tmp + result; } return result; } Hold this function when you're making your request.
How can non-repetitive values be inserted into SQL?
Software Programming • sql • • inna

2

0
Votes

2
Posts

0
Views

S

Indeed, you do not specify data types, database management system you use, etc.The following, I tested it in postgresql 8.4 and works:insert into tabla2 (id,rfc,nombrepersona) select id,rfc,nombrepersona from tabla1 where rfc in (select rfc from tabla1 group by rfc having count(rfc) = 1 limit 1) In having count(rfc) = 1, the 1 says the amount of times rfc should be present in table 1 to take into account. I hope it helps you.
S

Timer works early or doesn't work at all.
Software Programming • javascript html5 cs3 • • simrah

2

0
Votes

2
Posts

0
Views

E

Function createAllDate Waiting for a date from year, like 2017-08-30, but you're handing it in a wrong format. createAllDate( formElDeadline, formElTime ) { var allDate = formElDeadline, years = allDate.slice(0,4), months = allDate.slice(5,7), days = allDate.slice(8), times = formElTime, hours = times.slice(0,2), minutes = times.slice(3);
K

I don't understand how java works together with js.
Software Programming • javascript java spring • • kalyn

2

0
Votes

2
Posts

0
Views

Why do you need a front if I, through annotation on the Spring, give an address to finding information that can also be processed in the Java To be with the front?Don't worry about the java then. How are you with the annotations going to make a modern UI? To keep asking the server for the whole page, so the productivity of your website will be at the height of the Mariana Valley because he'll be asking for the whole website dynamic from the server?Well, I don't know how Bakend works and the front. together.The Front sends a request to the Bakend, which, after processing, sends a response.There's a goydes to make an application on the Spring, and there's a goydes to create. Annexes to js, but how to merge them into Did you work?So there's a lot of gays in the group, too, you need to stop with your choice and look for specific examples. Because spring is a bacon that will work out a request and answer. Here. https://ru.vuejs.org/v2/guide/ ♪ https://ru.reactjs.org/ ♪ https://angular.io/docs - it's the front, forget it. https://learn.javascript.ru/ where it's full.
A

Conflict Mootools and JQuery, some other way to make them work together different from using JQuery.noConflict()?
Software Programming • jquery mootools • • Amritpal

2

0
Votes

2
Posts

0
Views

K

After years of working with Joomla!, this is an old problem, well known in the community, because Joomla! used Mootools as its framework, however later appeared jQuery and the rest of history we know it.The problem lies in the use of $ by both, and in this case, given the amount of jQuery code it would appear that only these options remain:Use a popup window that supports jQuery or does not need any other dependency, something like https://limonte.github.io/sweetalert2/ with that you would avoid adding another JS library/framework.In the popup window you try to add, modify (or extend if possible) your code so that you do not use the functions $ and $$ of Mootools, which are "best" of https://developer.mozilla.org/en-US/docs/Web/API/Document/getElementById and https://developer.mozilla.org/en-US/docs/Web/API/Document/querySelectorAll respectively, which should not be as complicated to replace, although it depends on the implementation as it is done.This is explained in several parts of the Mootools website: http://mootools.net/core/docs/1.4.5/Element/Element http://mootools.net/blog/2009/06/22/the-dollar-safe-mode http://mootools.net/blog/2010/03/19/a-better-way-to-use-elements . This is perhaps the most relevant one.Here is the reference (initial) in the https://github.com/mootools/mootools-core/blob/4d1e7dfe4e79287b81360e1caa017d65c91eb2f9/Source/Element/Element.js :if (window.$ == null) Window.implement('$', function(el, nc){ return document.id(el, nc, this.document); }); if (window.$$ == null) Window.implement('$$', function(selector){ var elements = new Elements; if (arguments.length == 1 && typeof selector == 'string') return Slick.search(this.document, selector, elements); var args = Array.flatten(arguments); for (var i = 0, l = args.length; i < l; i++){ var item = args[i]; switch (typeOf(item)){ case 'element': elements.push(item); break; case 'string': Slick.search(this.document, item, elements); } } return elements; }); //</1.2compat> if (window.$$ == null) Window.implement('$$', function(selector){ if (arguments.length == 1){ if (typeof selector == 'string') return Slick.search(this.document, selector, new Elements); else if (Type.isEnumerable(selector)) return new Elements(selector); } return new Elements(arguments); }); CONCLUSIONDepending on the amount of work you have to do to adapt Mootools' "'s popup window', it may be a better idea to look for something equivalent in jQuery, or if you have the time and knowledge, adapt it so that there are no such conflicts, be it with JavaScript Vanilla, jQuery or Mootools.
B

Construction of non-cluster index
Software Programming • sql server sql • • Burma

2

0
Votes

2
Posts

0
Views

In tables with the existing cluster index in all other indices, the key of the cluster index shall be used as an indicator for the record. Thus, when searching for a non-cluster index, such tables first search the index and then search the cluster.In tables without a cluster index, all indices as indicators are used by RID, which is directly translated into the physical address of the disc. Thus, in tables without a cluster index, the search for any indexes is faster, since it is not necessary to look at the cluster.From the point of view of the operator DDL create index, there is no difference in syntaxis (except in the absence of the word clustered)
Field to number or rank distinct records - Oracle
Software Programming • sql oracle • • Mystic

2

0
Votes

2
Posts

0
Views

To make this numbering grouped, you can use the https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions001.htm#i81407 https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions137.htm , this allows to make groupings and orderings of specific records, for example: select ROW_NUMBER() OVER(partition by Atendimento order BY seq_exame) sequencia, t.* from SUA_TABELA t
J

Procedure does not update table with value NULL
Software Programming • sql null • • jules

2

0
Votes

2
Posts

0
Views

C

You can use the function https://docs.microsoft.com/pt-br/sql/t-sql/functions/isnull-transact-sql?view=sql-server-ver15 in SQL Server, basically it returns an alternate value when the value passed to it is zero:Example:ISNULL(WCoinC, 0) Use in your context:UPDATE CashShopData SET WCoinC=ISNULL(WCoinC, 0)+50 WHERE AccountID=@Account Another alternative would be the function COALESCE, which returns the first non-zero value found in a list. This solution also works in other databases like postgres, oracle, mysql...Example:COALESCE(WCoinC, WCoinD, WCoinE, 0)
Which trigger will work the perfume.
Software Programming • sql server • • carriann

2

0
Votes

2
Posts

0
Views

Z

All cascade reference actions, direct reference instructions DELETE or UPDATE, performed First. http://msdn.microsoft.com/ru-ru/library/ms186973%28v=sql.105%29.aspx http://msdn.microsoft.com/ru-ru/library/ms186973%28v=sql.105%29.aspx section of Triggers and cascade references
G

How does it work and how do the parameters of a function work?
Software Programming • javascript • • guilherme

2

0
Votes

2
Posts

0
Views

O

Well, first you have to know that a "function" is a piece of code that makes a specific function or task.A basic example is a mathematical calculus. Look at this function:function sumar( a, b){ console.log(a + b) } This function so it can work, it needs 2 parameters that are a and b (2 data or variables) so it can workLet's make a call for a function by passing the parameters:sumar( 1, 2) This what you will do is add 1 + 2 and show you in console the resultLet's see another example: I'm going to do a function that repeats me a code according to the times I pass it by parameters to the functionfunction repetir( repeticiones ){ for ( var i = 1; i <= repeticiones; i++){ console.log('repeticion numero' + i) } } We call the operation.repetir(4) // repetira el codigo 4 veces repetir(1000) // repetira el codigo mil veces

How will we work together with SQL repetitions?

Suggested Topics

Does this form of CRUD work well with SQL Y C#? Software Programming • c sharp sql • • zymir

Reset of repetitive lines (select) Software Programming • sql server sql • • terrea

SQL Find a staff member who worked in the office, whose location matches their address. Software Programming • mysql sql postgresql database • • Alberto

Will this form of interview work? Software Programming • html form • • Saumya

Validate DNI, CIF and NIE (Spain) in MYSQL? Software Programming • mysql sql • • chanisef

How to make SQL a request that will be sorted only according to the data received Software Programming • sql wpf • • Kadyn

How can non-repetitive values be inserted into SQL? Software Programming • sql • • inna

Timer works early or doesn't work at all. Software Programming • javascript html5 cs3 • • simrah

I don't understand how java works together with js. Software Programming • javascript java spring • • kalyn

Conflict Mootools and JQuery, some other way to make them work together different from using JQuery.noConflict()? Software Programming • jquery mootools • • Amritpal

Construction of non-cluster index Software Programming • sql server sql • • Burma

Field to number or rank distinct records - Oracle Software Programming • sql oracle • • Mystic

Procedure does not update table with value NULL Software Programming • sql null • • jules

Which trigger will work the perfume. Software Programming • sql server • • carriann

How does it work and how do the parameters of a function work? Software Programming • javascript • • guilherme

Does this form of CRUD work well with SQL Y C#?
Software Programming • c sharp sql • • zymir

Reset of repetitive lines (select)
Software Programming • sql server sql • • terrea

SQL Find a staff member who worked in the office, whose location matches their address.
Software Programming • mysql sql postgresql database • • Alberto

Will this form of interview work?
Software Programming • html form • • Saumya

Validate DNI, CIF and NIE (Spain) in MYSQL?
Software Programming • mysql sql • • chanisef

How to make SQL a request that will be sorted only according to the data received
Software Programming • sql wpf • • Kadyn

How can non-repetitive values be inserted into SQL?
Software Programming • sql • • inna

Timer works early or doesn't work at all.
Software Programming • javascript html5 cs3 • • simrah

I don't understand how java works together with js.
Software Programming • javascript java spring • • kalyn

Conflict Mootools and JQuery, some other way to make them work together different from using JQuery.noConflict()?
Software Programming • jquery mootools • • Amritpal

Construction of non-cluster index
Software Programming • sql server sql • • Burma

Field to number or rank distinct records - Oracle
Software Programming • sql oracle • • Mystic

Procedure does not update table with value NULL
Software Programming • sql null • • jules

Which trigger will work the perfume.
Software Programming • sql server • • carriann

How does it work and how do the parameters of a function work?
Software Programming • javascript • • guilherme