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).

Recurring SQL fields in one field, condition

Burma

A table

Id | Date | Title      | Unique Id
1   2020    some title   1

2   2021    some title   2

2   2020    some title   3

All ID repeat lines should be merged into one (the only date known to be different), with the date to be made (firstDate - secondDate). For example, the result should be:

Id | Date        | Title      | Unique Id
1   2020          some title   1

2   2020-2021     some title   2

R
rosemadder last edited by
I helped.
```
STRING_AGG(Date, '-')
```
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

A

check the difference between one and the other without conditions
Software Programming • python python 3.x python 2.x • • authera

2

0
Votes

2
Posts

0
Views

C

In [57]: def chk(a,b): ...: return a % b and 'не делится' or 'делится' ...: In [58]: chk(15, 5) Out[58]: 'делится' In [59]: chk(15, 4) Out[59]: 'не делится'
R

How do you transfer the values of one field to another?
Software Programming • javascript jquery • • Rossere

2

0
Votes

2
Posts

0
Views

You need to use it properly. .each()That's why http://jquery.page2page.ru/index.php5/%D0%92%D1%8B%D0%B7%D0%BE%D0%B2_%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8_%D0%B4%D0%BB%D1%8F_%D1%8D%D0%BB%D0%B5%D0%BC%D0%B5%D0%BD%D1%82%D0%BE%D0%B2_%D0%BD%D0%B0%D0%B1%D0%BE%D1%80%D0%B0 It clearly states that the method has one use:.each(callback(index, domElement) You don't have any parameters in your bell. So we just need to rewrite the code a little bit. It made a note, but the principle is clear:function getSum() { var $target = $('.term'), sum = 0; //тот кусок, который вам нужен $target.each(function(idx, item) { sum += parseInt($(this, item).val()) || 0; }); $('.sumInput').val(sum); $('.sum').text(sum); } document.getElementById('getSum').addEventListener('click', getSum, false);input { display: block; }<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script> <input type="text" class="term" placeholder="Слагаемое" /> <input type="text" class="term" placeholder="Слагаемое" /> <input type="text" class="term" placeholder="Слагаемое" /> <input type="text" class="term" placeholder="Слагаемое" /> <input type="button" id="getSum" value="Посчитать" /> <input type="text" class="sumInput" placeholder="Сумма" /> <div class="sum"></div>
T

Search sql for any field
Software Programming • sql server • • Trenton

2

0
Votes

2
Posts

0
Views

You can assemble the query as a string and then run it with the sp sp_executesql:declare @campo varchar(10) = 'proveedor'; declare @sql varchar(1000) = CONCAT('select * from proveedor where ',@campo, ' like %va%'); sp_executesql @sql
S

Several joins in one field
Software Programming • sql join • • simrah

2

0
Votes

2
Posts

0
Views

E

Try this:(SELECT p.ID, p.NAME, ap.PRICE_AUTO as PRICE FROM products p JOIN `auto_prices` ap ON p.ID = ap.PRODUCT_ID) UNION (SELECT p.ID, p.NAME, mp.PRICE_MOTO as PRICE FROM products p JOIN `moto_prices` mp ON p.ID = mp.PRODUCT_ID) Well, if you've got this structure of the tables and there's nothing else out there, maybe you should do it differently?Separately. auto_prices and moto_prices No need. Price One table can be kept. Right in. products♪ In this case. Adding a column category Table categoriesby linking these two tables. It's gonna be that you'll put every product in category/type... that it's a photo, a rope, a moto, a proto, etc. And if you want to choose the price, depending on the product, you can use that table with categories. And in this case, you don't have to make any extra moves, you'll have to write enough. SELECT id, name, price FROM products
S

It is possible to put a "IF" condition in means to inner joins and other conditions of a where in SQL Server?
Software Programming • sql server sql • • Saumya

2

0
Votes

2
Posts

0
Views

C

Simpler way: and (bol_portfolio = @eh_port or @eh_port = 2) In this case neither the procedure you would need to validate it, because when the parameter is worth two the comparison with the bol_portfolio will be ignored.EditedDetail: Oracle sql validates from right to left, that is, if @eh_port for 2, it will not even perform the comparison with bol_portifolio
Get the sum of some lines from one field, depending on the value of another field
Software Programming • php mysql • • emmalee

2

0
Votes

2
Posts

0
Views

It seems to me that you're looking for something like this:SELECT * FROM ( SELECT *,subcuenta-43e6 subcuentad_id FROM copia_subcuentas ) c1 JOIN ( SELECT subcuentad_id,SUM(imported) total_imported FROM copia_diarioslineas GROUP BY 1 ) c2 USING(subcuentad_id); The drawback is that only one of your example records matches me, 43000001. The rest of the accounts must be codified differently than how you have codified ids. Change the bills, or ids, and it will work properly.Accounts: 1, 5, 6, 7, 9, 10, 20, 40, 50Ids: 1, 4, 16, 17, 21, 23I hope that's what you were looking for. Let me in the comments any doubt or discrepancy regarding what you need.
MySQL Server Sparks up to 400% Please help!
SQL, Database Testing • mysql my.c languagenf • • emmalee

2

0
Votes

2
Posts

0
Views

S

(Preliminary review of the pastbin) There are 13 identical indexes like this KEY `post_status` (`post_status`,`post_type`,`post_date`), Similarly for KEY `autoload` (`autoload`), Is something automatically generating them? Keep one, DROP the others. Prefix indexing is virtually useless: KEY `post_name` (`post_name`(191)), See this for 5 workarounds. Ditto for all the other "prefix indexes" with (191). Partial EAV optimization: See this for how to speed up postmeta tables. Wildcards and OR: This (and similar constructs) is inefficient: OR (9ja_posts.post_excerpt LIKE '%paw%') OR (9ja_posts.post_content LIKE '%paw%')) because: The leading wildcard prevents use of an index OR prevents the use of an index Consider having a FULLTEXT index on the combination of columns. IN ( SELECT ) may not be optimal: NOT IN ( SELECT ... ) Better options: EXISTS ( SELECT ... ) or LEFT JOIN .. ON .. IS NULL Pagination via OFFSET, as in ORDER BY ... LIMIT 260, 10 is inefficient in multiple ways. This discusses how to "remember where you left off" as a significantly faster way. (Caveat: It does not apply in all situations.) It is rare that I encounter a Question that clearly needs help from 3 of my blogs. This Question wins the prize. Summary My 7 bits of advice are mostly independent of each other, and each may produce a noticeable improvement. It would be hard to predict which would give you the most bang for the buck. (Hmmm... I wonder if '7 tips' is a new record.) Try to implement much of what I advise here, then (if you still have trouble), come back for more advice.
Conditional to print on PL/SQL
Software Programming • oracle pl sql infomaker • • morde

2

0
Votes

2
Posts

0
Views

R

In InfoMaker it is possible to program the Visible property, type : If(calculus = 5,1,0) Obs:1=true and 0=False)
C

SQL - how do we remove duplicates of OBD records?
Software Programming • mysql sql • • courtlanda

2

0
Votes

2
Posts

0
Views

J

Action Algorithm:understand what criteria the records should be considered to be identicalwrite a request to search for duplicate data sets (possibly not lines, only data sets)To understand how to decide which of the records to be left.to correct the request accordingly so that it withdraws all duplicate records other than those to be left.Request delete where id in (subquery)♪I mean, it's kind of something like that, if you think uniqfield a field that should be unique, leave a line with a minimum id:delete from tablename where id in ( select id from ( select id from tablename join ( select min(id) as firstdup, uniqfield from tablename group by uniqfield ) duplicates using(uniqfield) where id != firstdup ) subqueryhack ) For a combination of two fields to show that it changesdelete from tablename where id in ( select id from ( select id from tablename join ( select min(id) as firstdup, uniqfield1, uniqfield2 from tablename group by uniqfield1, uniqfield2 ) duplicates using(uniqfield1, uniqfield2) where id != firstdup ) subqueryhack ) delete Total mysql it will not directly remove from the table that the sub-request is reading, but it is costed by another request if necessary.If it doesn't matter what rows are left and which versions of the CBD are removed and allowed, then a unique index could just be hung up to mysql 5.7.4. ignoreALTER IGNORE TABLE mytable ADD UNIQUE INDEX myindex (A, B, C, D); Which will remove all the duplicates in these fields except one line. In current versions ignore conduct removed and causing a mistake. I didn't know why they were removed, most likely because of the invisible behavior, which line would be removed and the general course of return to SQL-standard.
C

creating a field in sql
Software Programming • sql server sql • • Cleofas

2

0
Votes

2
Posts

0
Views

R

On the one hand, in this case, it is sufficient to change the field type. number c int ♪ char(5):CREATE TABLE man ( id INT IDENTITY(1, 1) NOT NULL, number CHAR(5) NOT NULL CONSTRAINT CK_man_number CHECK (number LIKE '[0-9][0-9] [0-9][0-9]'), CONSTRAINT PK_man PRIMARY KEY (ID) ); On the other hand, the formatting is more common to the front-end, and it may be worth considering keeping a unique number in numerical format. smallint (2 bait versus 5) char(5)CREATE TABLE man ( id INT IDENTITY(1, 1) NOT NULL, number smallint NOT NULL CONSTRAINT CK_man_number CHECK (number between 1000 and 9999), CONSTRAINT PK_man PRIMARY KEY (ID) ); Also in Sql Server, the function began with the 2012 version FORMAT♪ In the case of a type field smallint expression FORMAT(number, '## ##') (if indeed required in requests) will provide the necessary formatting. You can even put it in shape. calculated column♪
E

How to insert this text in PostgreSQL?
Software Programming • sql postgresql delphi sql update ric languagehtextbox • • emran

2

0
Votes

2
Posts

0
Views

E

Part of that question I have already answered you here https://pt.stackoverflow.com/questions/310219/ritchedit-delphi-bagun%C3%A7a-texto-ao-gravar-no-banco-postgresql/310981#310981 About recording blobs using instructions SQL do so:procedure TForm1.Button1Click(Sender: TObject); var q: TFDQuery; s: TMemoryStream; begin s := TMemoryStream.Create; RichEdit1.Lines.SaveToStream(s); s.Seek(0, soFromBeginning); q := TFDQuery.Create(Self); q.Connection := FDConnection1; q.SQL.Text := 'update tabela set campobytea = :b where (id = 1)'; q.ParamByName('b').LoadFromStream(s, ftBlob); q.ExecSQL; end; This code is just to exemplify. Consider the use of TRY EXCEPT and TRY FINALY in the production code.
M

Is it possible to avoid filesort?
SQL, Database Testing • mysql performance query performance • • meriah

2

0
Votes

2
Posts

0
Views

T

The docs say In some cases, MySQL cannot use indexes to resolve the ORDER BY, although it still uses indexes to find the rows that match the WHERE clause. These cases include the following: and then go on to list many circumstances that prevent MySQL from using indexes. Among them are You use ORDER BY on different keys The key used to fetch the rows is not the same as the one used in the ORDER BY and there are probably others. To avoid a filesort, you have to find a way to get what you want without running into any of those (many) documented conditions. You can also Increase the size of the sort_buffer_size variable. Increase the size of the read_rnd_buffer_size variable. Use less RAM per row by declaring columns only as large as they need to be to hold the values stored in them. Change tmpdir to point to a dedicated file system with large amounts of free space. (Same link.) Also see docs for Optimizing LIMIT Queries, which interacts with ORDER BY.
D

join value in a RETURNING which is not inserted
SQL, Database Testing • postgresql join insert • • derk

2

0
Votes

2
Posts

0
Views

D

Perhaps there's a better alternative but I can only think of joining back to the 2 tables. This assumes that new_table has a unique constraint on (x,y) and that these columns are not nullable: with ins (id, x, y) as ( insert into new_table (x, y) select A.x, B.y from A join B on A.w = B.z returning id, x, y ) -- insert into another_table (id, z) select ins.id, B.z -- whatever columns from the 3 tables from ins join A on A.x = ins.x join B on B.y = ins.y and A.w = B.z ;
J

School marks database with "mark categories"
SQL, Database Testing • sql server database design • • jules

2

0
Votes

2
Posts

0
Views

R

Marks are related to categories and subjects, so you need a SubjectId column in the Marks table so that you know what subject each record relates to. CREATE TABLE [dbo].[Marks] ( [Id] INT IDENTITY (1, 1) NOT NULL, [CategoryId] INT NOT NULL, [SubjectId] INT NOT NULL, [Name] NVARCHAR(MAX) NOT NULL, [Value] DECIMAL(18,3) NOT NULL ) CREATE TABLE[dbo].[Categories] ( [Id] INT IDENTITY (1, 1) NOT NULL, [Name] NVARCHAR(MAX) NOT NULL, [Average] decimal(18,3) NOT NULL ) CREATE TABLE[dbo].[Subjects] ( [Id] INT IDENTITY (1, 1) NOT NULL, [Name] NVARCHAR(MAX) NOT NULL, [Teacher] NVARCHAR(MAX) NOT NULL, [Average] decimal(18,3) NOT NULL, ) It seems as if you were envisioning creating separate category records for every subject (i.e., you would have a tests category for writing, and a tests category for math), but you should just need one category of each type of category (tests, written, lab, etc.). The categories get tied to the subjects by the marks table, which links to both of the other tables.
E

SQL Server service unresponsive
SQL, Database Testing • sql server memory • • emerson

2

0
Votes

2
Posts

0
Views

N

Need more info like SELECT @@VERSION, do you use CLR procs, have you set max memory on both the instances? Were you able to look at which spids were taking most resources and why? To catch the intermittent cpu spikes, you may have to setup a trace and here is one such script. http://www.sqlsoldier.com/wp/sqlserver/catchingtransientcpuspikesusingsqltrace

Recurring SQL fields in one field, condition

Suggested Topics

check the difference between one and the other without conditions Software Programming • python python 3.x python 2.x • • authera

How do you transfer the values of one field to another? Software Programming • javascript jquery • • Rossere

Search sql for any field Software Programming • sql server • • Trenton

Several joins in one field Software Programming • sql join • • simrah

It is possible to put a "IF" condition in means to inner joins and other conditions of a where in SQL Server? Software Programming • sql server sql • • Saumya

Get the sum of some lines from one field, depending on the value of another field Software Programming • php mysql • • emmalee

MySQL Server Sparks up to 400% Please help! SQL, Database Testing • mysql my.c languagenf • • emmalee

Conditional to print on PL/SQL Software Programming • oracle pl sql infomaker • • morde

SQL - how do we remove duplicates of OBD records? Software Programming • mysql sql • • courtlanda

creating a field in sql Software Programming • sql server sql • • Cleofas

How to insert this text in PostgreSQL? Software Programming • sql postgresql delphi sql update ric languagehtextbox • • emran

Is it possible to avoid filesort? SQL, Database Testing • mysql performance query performance • • meriah

join value in a RETURNING which is not inserted SQL, Database Testing • postgresql join insert • • derk

School marks database with "mark categories" SQL, Database Testing • sql server database design • • jules

SQL Server service unresponsive SQL, Database Testing • sql server memory • • emerson

check the difference between one and the other without conditions
Software Programming • python python 3.x python 2.x • • authera

How do you transfer the values of one field to another?
Software Programming • javascript jquery • • Rossere

Search sql for any field
Software Programming • sql server • • Trenton

Several joins in one field
Software Programming • sql join • • simrah

It is possible to put a "IF" condition in means to inner joins and other conditions of a where in SQL Server?
Software Programming • sql server sql • • Saumya

Get the sum of some lines from one field, depending on the value of another field
Software Programming • php mysql • • emmalee

MySQL Server Sparks up to 400% Please help!
SQL, Database Testing • mysql my.c languagenf • • emmalee

Conditional to print on PL/SQL
Software Programming • oracle pl sql infomaker • • morde

SQL - how do we remove duplicates of OBD records?
Software Programming • mysql sql • • courtlanda

creating a field in sql
Software Programming • sql server sql • • Cleofas

How to insert this text in PostgreSQL?
Software Programming • sql postgresql delphi sql update ric languagehtextbox • • emran

Is it possible to avoid filesort?
SQL, Database Testing • mysql performance query performance • • meriah

join value in a RETURNING which is not inserted
SQL, Database Testing • postgresql join insert • • derk

School marks database with "mark categories"
SQL, Database Testing • sql server database design • • jules

SQL Server service unresponsive
SQL, Database Testing • sql server memory • • emerson