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 do we combine the values of several lines of the table?

Z
zymir last edited by

There is a table of type:
01:00, Parameter1, Value
01:00, Parameter2, Value
01:00, Parameter3, Value
♪ ♪ ♪ ♪
0300, Parameter1, Value
0300, Parameter2, Value
0300, Parameter 3, meaning, etc.
Can SQL be requested to obtain such a sample
01:00, ValueParameter1, ValueParameter2, ValueParameter3
♪ ♪ ♪
0300, ValueParameter1, ValueParameter2, ValueParameter3
Thank you!
Reply Quote 0
1 Reply Last reply

Marcee

Probably. Something like:

select time, sum (case when parname='Параметр1' then parval else 0 end) as par1, sum (case when parname='Параметр2' then parval else 0 end) as par2, sum (case when parname='Параметр3' then parval else 0 end) as par3 from t group by time;

If there are rows with the same parameter and time, you will receive the sum (may use other aggregate functions)

2
Posts

0
Views

Suggested Topics

User value of sum according to line values
Software Programming • javascript functions google apps script • • Marcee

2

0
Votes

2
Posts

0
Views

We need to operate with the entry point. User formulas require input data. Don't tell me to use it. getValues and everything./** * Выводит что-то * * @param {Range} scheta - Колонка счетов. * @param {Range} fios - Колонка ФИО. * @param {Range} vizovy - Колонка вызовов. * @param {Number} row - Вывести для конкретной строки. * @return что надо. * @customfunction */ function departure(scheta, fios, vizovy, row) { try { if (!((scheta.length == fios.length) == (vizovy.length == fios.length))) return '#SIZEOF'; var stack = {}; for (var i = 0; i < scheta.length; i++) { var schet = ("" + scheta[i][0]) !== "" ? scheta[i][0] : "undefined"; if (!stack.hasOwnProperty(schet)) { stack[schet] = { once: true, sumFio: 0, sumEmpty: 0, hasFio: false, }; } else { stack[schet].once = false; } if (fios[i][0]) { stack[schet].sumFio += vizovy[i][0]; stack[schet].hasFio = true; } else { stack[schet].sumEmpty += vizovy[i][0]; } } if (row && row > 0) { var schet_ = ("" + scheta[row - 1][0]) !== "" ? scheta[row - 1][0] : "undefined"; return stack[schet_].hasFio ? stack[schet_].sumFio : 0; } var res = []; for (var i = 0; i < scheta.length; i++) { var row = []; var schet = ("" + scheta[i][0]) !== "" ? scheta[i][0] : "undefined"; var item = stack[schet].hasFio ? stack[schet].sumFio : 0; row.push(item); res.push(row); } return res; } catch (err) { return err.message; } } For the following data =departure(A2:A13,B2:B13,C2:C13) return the calculation for the entire mass=departure(A2:A13,B2:B13,C2:C13, 1) Reset the calculation for line 1 and the specified mass https://docs.google.com/spreadsheets/d/1wcoDlLDvec3LdJzOmbWwMO1PdZaZu21rDyXMJIxgP5I/copy
S

SQL request using JOIN
Software Programming • mysql sql • • simrah

2

0
Votes

2
Posts

0
Views

-- выбрать имена авторов SELECT a.author_name -- из таблиц авторов и книг FROM authors a, books b -- где идентификатор автора совпадает с идентификатором автора книги WHERE a.author_id = b.author_id -- причём для данного автора GROUP BY a.author_name -- количество (уникальных) идентификаторов книг больше 10 HAVING COUNT( /* DISTINCT */ b.book_id) > 10 If you need JOIN, -- выбрать имена авторов SELECT a.author_name -- из таблиц авторов и книг FROM authors a INNER JOIN books b -- где идентификатор автора совпадает с идентификатором автора книги ON a.author_id = b.author_id -- причём для данного автора GROUP BY a.author_name -- количество (уникальных) идентификаторов книг больше 10 HAVING COUNT( /* DISTINCT */ b.book_id) > 10
S

Calculation of different values
Software Programming • sql oracle select plsql • • shizuka

2

0
Votes

2
Posts

0
Views

select name, date, etc, wtf, sum(case when status =1 then amount else 0 end) as "status_1", sum(case when status =2 then amount else 0 end) as "status_2", sum(amount) as "all_amount" from foo, wtf, mega_table
S

how to read a line of a txt and autofollow go to the next line and save that value in a variable
Software Programming • python txt • • Saumya

2

0
Votes

2
Posts

0
Views

B

To do this you would have to use readlines(). Returns a list with all the lines in the file.f = open("proxy.txt","r") while(True): linea = f.readline().strip() print(linea) if not linea: break f.close() Output:157.245.251.117:8080 159.203.44.177:3128 157.245.254.160:8080 I hope I helped you.
None in Python should not be semantically equal to the SQL Null?
Software Programming • python sql • • Analeea

2

0
Votes

2
Posts

0
Views

This behavior occurs so because language was defined like this.In the official language documentation https://docs.python.org/pt-br/3/reference/datamodel.html#special-method-names is written:A class can implement certain operations that are called by special syntax (such as arithmetic or subscript operations and slicing), defining methods with special names. This is the approach from Python to operator overload, allowing classes define their own behavior in relation to operators of language.Soon more below are defined the comparison methods: https://docs.python.org/pt-br/3/reference/datamodel.html#object.__ge__ These are the so-called methods of “rich comparison”. The correspondence between the operator symbols and the method names is as follows:x<y flame x.__lt__(y)x<=y flame x.__le__(y)x==y flame x.__eq__(y)x!=y flame x.__ne__(y)x>y flame x.__gt__(y)x>=y flamex.__ge__(y)Replacing the comparison None==None by the respective method of comparison we will have:>>> print(None.__eq__(None)) True Now a care should be taken when comparing None with other values:>>> print(None == False) False >>> print(None == True) False This is because the method of comparison None.__eq__() for other values other than None is not defined and by default, object implements __eq__() using is, returning NotImplemented in the case of a false comparison: True if x is y else NotImplemented, implying that anything other than None compared to None It is False.>>> print(None.__eq__(True)) NotImplemented >>> print(None.__eq__(False)) NotImplemented It reinforces the alert made in https://www.python.org/dev/peps/pep-0008/#id51 :Comparisons with singletons like None must always be made with is or not , never with equal operatorsAlso, be careful when writing if x when you really mean if x not is None - for example, when testing whether a variable or argument whose pattern is None was defined with some other value. The other value can have a type (like a container) that can be false in a boolean context!See this example taken from https://www.w3schools.com/python/trypython.asp?filename=demo_ref_keyword_none2 which illustrates the situation:>>> x = None >>> if x: ... print("Você pensa que None é True?") ... elif x is False: ... print ("Você pensa que None é False?") ... else: ... print("None não é True ou False, None apenas None...") None não é True ou False, None apenas None... And no use forcing a class to emulate a logical value None:>>> class teste(): ... def bool(self): ... return None >>> t = teste() >>> print(bool(t)) Traceback (most recent call last): File "main.py", line 6, in <module> print(bool(t)) TypeError: bool should return bool, returned NoneType
J

Coping the table range through openById and inserting into the nearest empty line in the active table
Software Programming • google apps script googlesheets • • jules

2

0
Votes

2
Posts

0
Views

E

const dataSheetId = 'тут ID листа откуда берем данные' const dataSheetName = 'List1' const dataRange = 'A1:A' function myFunction() { // защита от дурака) let answer = Browser.msgBox('Добавить данные?', Browser.Buttons.YES_NO); if (answer == 'yes') { // Получаем активный (в данный момент) лист наверное с таблицей var s = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); // Лист с данными var ds = SpreadsheetApp.openById(dataSheetId).getSheetByName(dataSheetName); // Получаем данные var values = ds.getRange(dataRange + ds.getLastRow()).getValues(); // немного магии, eсли копируемый диапазон больше 1 столбца, вводим в map r[0], r[1] и т.д., где r[0] первый столбец var arr = values.map(function (r) { return [r[0]]; }); // столбец 1 добавляем данные, если больше одного столбца s.getRange(s.getActiveCell().getRow(), s.getActiveCell().getColumn(), arr.length, arr[0].length).setValues(arr); s.getRange(s.getActiveCell().getRow(), s.getActiveCell().getColumn(), arr.length, 1).setValues(arr); // } }
A

Oracle - Select distinct in just one column
Software Programming • sql oracle • • authera

2

0
Votes

2
Posts

0
Views

J

As @Confundir said in the comment, you can simply use the grouping with the Max(), in this way: select ac.cod_matricula, he.cod_usuario_log, max(he.dt_atualiza_log) dt_atualiza_log, he.txt_ip_log, he.cod_usuario_log_del, he.dt_atualiza_log_del from OW.HIST_HISTORICO HE, OW.ALUNO AC where ac.cod_aluno_curso = he.cod_aluno_curso and he.cod_usuario_log = '1234567' group by ac.cod_matricula, he.cod_usuario_log, he.txt_ip_log, he.cod_usuario_log_del, he.dt_atualiza_log_del
E

How to create a Spring boot product filter (Thymeleaf)
Software Programming • java sql spring spring mvc • • emran

2

0
Votes

2
Posts

0
Views

E

public interface itemRepo extends CrudRepository<ItemModel,Long> { @Query("select * from youTable where type == :type and price < :price") LinkedList<ItemModel>findByTypeOrPriceOrSale(@Param("type") String type,@Param("price") int price,boolean sale); } Write your request with the required parameters.
E

Error when inserting new column with MySQL
Software Programming • mysql sql • • elysha

2

0
Votes

2
Posts

0
Views

the problem you have are the default values you use for dates. Specifically the two values you put to '0000-00-00 00:00:00'I recommend using CURRENT_TIMESTAMP as default value. You can also place the smallest valid date possible '1971-01-01 00:00:00', if you need that value for the logic of your algorithms in other sections.I hope the solution works for you.
J

No server at MySQL
Software Programming • mysql sql • • jonetta

2

0
Votes

2
Posts

0
Views

R

Look what the error is when you're in the window of the installer or Log of the operating system files. Then, on ID or on other grounds, you can move on to its elimination. And if that doesn't help, then use the Menu or the official program website. Typical user error - use of a gap in names. And MySQL can't handle the symbol of the malfunction in the name of service. If that's true, just change the name to one without the gaps.
Z

When adding new lines, the table does not scream the input value
Software Programming • javascript html jquery • • zymir

2

0
Votes

2
Posts

0
Views

T

Do it like that: http://jsfiddle.net/11111000000/jym2e8mg/1/ $('#table1').on('keyup','input[name="price"],input[name="quantity"]', function(){ and beyond: http://jsfiddle.net/11111000000/jym2e8mg/2/ function(ev){ var tr = $(this).parents('tr'); tr.find('input[name="total"]').val(parseInt(tr.find('input[name="price"]').val())*parseInt(tr.find('input[name="quantity"]').val())); }
P

Problems after installation DataGrip (JetBrains)
Software Programming • mysql sql jetbrains datagrip • • Pearlaqua

2

0
Votes

2
Posts

0
Views

G

Side menu display in DataGrip.Once the project has been established, do the team. cmd + eto open the menu and choose Database (see picture 1)to open the side menu (see picture 2)♪ After that (for more convenience) we'll move the menu to the left by pressing on the pole and selecting Move to -> Left (see picture 3)♪Construction/addition of new databasesTo add the database, press + in the menu we built (see picture 2)♪ Choose Data Source and database you'll work with. (see picture 4)♪ Once you have chosen the required item from the list, fill the data for the current database (see picture 5)♪Don't worry, you're the one who's done it! At the very bottom of the page of filling the form of connection may burn Download missing driver files (see picture 5). Click on Download You'll find the driver you need.Before you press "OK" after filling the form Press. Test connection♪ This will eliminate the reversal of databases to the menu in the event of an error in the form of connection. To move quickly into the menu of databases - File -> Data Sources or combination of keys cmd + ;♪Figure 1: Figure 2: Figure 3: Figure 4: Figure 5:
R

Join SQL tables from different codes according to the last digits of the id
Software Programming • sql • • Raziyah00

2

0
Votes

2
Posts

0
Views

C

So suddenly I think you're subtracting 2000 to the code. uaca_codigofor example: SELECT * FROM FACULTAD F INNER JOIN UNIDADES_ACADEMICAS U ON F.FACU_CODIGO = (U.UACA_CODIGO -2000);
A

Logic for instruction SQL - Sum of values between Table A and Table B
Software Programming • sql sqlite sqlite3 • • Amritpal

2

0
Votes

2
Posts

0
Views

N

I think yours Inner Join this wrong spoke the clausura ON, I did not try in the sqlite but most functions different. Alem de vc is comparing table. id with table_a. id and table_b.id with table_b.idSELECT tabela_A.descricao FROM tabela_A INNER JOIN tabela_B on tabela_b.id = tabela_a.id where(SELECT SUM(tabela_A.valor) FROM tabela_A INNER JOIN tabela_B on tabela_b.id = tabela_a.id GROUP BY tabela_B.descricao) < tabela_B.valor GROUP BY tabela_B.descricao
B

How to pass values from one column to two different columns in the same MySql table without the values being repeated?
Software Programming • mysql sql • • Burma

2

0
Votes

2
Posts

0
Views

T

Try using subconsults. Something like that should serve you:SELECT a.articulo_id, (SELECT b.foto FROM photos b WHERE b.foto LIKE '%medium.jpg' AND b.service_id = a.service_id AND b.articulo_id = a.articulo.id) AS medium, (SELECT b.foto FROM photos b WHERE b.foto LIKE '%big.jpg' AND b.service_id = a.service_id AND b.articulo_id = a.articulo.id) AS big FROM photos a WHERE a.service_id = 1 Although I would do it would be to create a field on the table for each size, so when consulting it is much easier.

How do we combine the values of several lines of the table?

Suggested Topics

User value of sum according to line values Software Programming • javascript functions google apps script • • Marcee

SQL request using JOIN Software Programming • mysql sql • • simrah

Calculation of different values Software Programming • sql oracle select plsql • • shizuka

how to read a line of a txt and autofollow go to the next line and save that value in a variable Software Programming • python txt • • Saumya

None in Python should not be semantically equal to the SQL Null? Software Programming • python sql • • Analeea

Coping the table range through openById and inserting into the nearest empty line in the active table Software Programming • google apps script googlesheets • • jules

Oracle - Select distinct in just one column Software Programming • sql oracle • • authera

How to create a Spring boot product filter (Thymeleaf) Software Programming • java sql spring spring mvc • • emran

Error when inserting new column with MySQL Software Programming • mysql sql • • elysha

No server at MySQL Software Programming • mysql sql • • jonetta

When adding new lines, the table does not scream the input value Software Programming • javascript html jquery • • zymir

Problems after installation DataGrip (JetBrains) Software Programming • mysql sql jetbrains datagrip • • Pearlaqua

Join SQL tables from different codes according to the last digits of the id Software Programming • sql • • Raziyah00

Logic for instruction SQL - Sum of values between Table A and Table B Software Programming • sql sqlite sqlite3 • • Amritpal

How to pass values from one column to two different columns in the same MySql table without the values being repeated? Software Programming • mysql sql • • Burma

User value of sum according to line values
Software Programming • javascript functions google apps script • • Marcee

SQL request using JOIN
Software Programming • mysql sql • • simrah

Calculation of different values
Software Programming • sql oracle select plsql • • shizuka

how to read a line of a txt and autofollow go to the next line and save that value in a variable
Software Programming • python txt • • Saumya

None in Python should not be semantically equal to the SQL Null?
Software Programming • python sql • • Analeea

Coping the table range through openById and inserting into the nearest empty line in the active table
Software Programming • google apps script googlesheets • • jules

Oracle - Select distinct in just one column
Software Programming • sql oracle • • authera

How to create a Spring boot product filter (Thymeleaf)
Software Programming • java sql spring spring mvc • • emran

Error when inserting new column with MySQL
Software Programming • mysql sql • • elysha

No server at MySQL
Software Programming • mysql sql • • jonetta

When adding new lines, the table does not scream the input value
Software Programming • javascript html jquery • • zymir

Problems after installation DataGrip (JetBrains)
Software Programming • mysql sql jetbrains datagrip • • Pearlaqua

Join SQL tables from different codes according to the last digits of the id
Software Programming • sql • • Raziyah00

Logic for instruction SQL - Sum of values between Table A and Table B
Software Programming • sql sqlite sqlite3 • • Amritpal

How to pass values from one column to two different columns in the same MySql table without the values being repeated?
Software Programming • mysql sql • • Burma