python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - hana

HANA SQL Select table into variable and for loop issue

I have a table in HANA that has the following columns: Customer(varchar), Day(varchar), Item(varchar), Quantity (decimal), Cost(decimal) My goal is to have a sql procedure that will duplicate the tabl...
test-img

shaheed313

sql

variables

hana

Votes: 0

Answers: 2

Latest Answer

if you want to double your values, you don't need loops or variables. the following doubles all ITEMs with a curent timestamp INSERT INTO "TABLE_NAME" ("ITEM", "MYDATETIME&qu...
test-img

nbk

Divide the column into several, based on condition (SQL or Python)

Maybe some of you know how to solve my problem (Hana SQL or Python): I have a column like this: id reason 1 1;2;3;5;6;7;8;10;13 2 1;2;4;5;6 3 4;7;8;9 4 1;2;3;10;11;12;13 5 2;4 And ...
test-img

Julia Lukach

python

sql

function

split

hana

Votes: 0

Answers: 1

Latest Answer

You can use HANA's string functions to search for patterns using regular expressions. In this case, you may want to search for the pattern, where your respective reason code is surrounded by either se...
test-img

Mathias Kemeter

union and select based on conditions

I have two tables SAP HANA. I want to do a union of these two tables by selecting some common columns in the them. Below are the things I want to satisfy while doing the union. 1) SELECT ALL product_k...
test-img

nmr

sql

hana

Votes: 0

Answers: 1

Latest Answer

I propose the below, where the first part pulls all product keys from table_a where a match is found in table_b by using an inner join. Then the union all pulls in all keys from table_b where a match ...
test-img

Tom E

Get last value based on a condition on ordered table in SQL

I have a table representing product groups. Groups are defined by row number and their Type. Hence here we have 2 groups, the group is defined by the Type A, the Type B being components. Row numbe...
test-img

tmhnr

sql

rdbms

hana

Votes: 0

Answers: 1

Latest Answer

You can achieve the desired result by using a join in conjunction with a group-by. Test Data CREATE TABLE TEST (ROW_NUMBER integer, TYPE varchar(1)); INSERT INTO test VALUES (0, 'A'); INSERT INTO tes...
test-img

Mathias Kemeter

Posts

Questions

Blogs

Jobs