Questions tagged [analytical]
82 questions
-1
votes
1 answer
Teradata: Case statement in analytical function
I've a case where the data needs to be represented based on the events
I need to achieve the following output
Explanation:
ABC is represented thrice here and you can see date being different,
Initial Balance is the first_value of the ABC and the…
user2653353
- 83
- 1
- 1
- 9
-1
votes
1 answer
mysql not having LEAD and LAG Functions
I'm not able to execute LEAD and LAG Functionality in MYSQL.
Do I need to install anything in MySQL Workbench to work it properly?
sairamdgr8
- 47
- 1
- 10
-1
votes
2 answers
Get range between FIRST_VALUE and LAST_VALUE
timestamp
id
scope
2021-01-23 12:52:34.159999 UTC
1
enter_page
2021-01-23 12:53:02.342 UTC
1
view_product
2021-01-23 12:53:02.675 UTC
1
checkout
2021-01-23 12:53:04.342 UTC
1
search_page
2021-01-23 12:53:24.513 UTC
1
checkout
I…
Oscar Copado
- 41
- 7
-1
votes
2 answers
Can somebody please push me in right direction
My code below to delete duplicate entries
with mytable as
(
select a.*,
row_number() over(partition by emp_id order by emp_id) as Row_number
from employee_Details2 a
)
delete from mytable
where Row_number=2;
Error:
*ORA-00928: missing SELECT…
Sanket kamble
- 1
- 1
-1
votes
2 answers
Find the youngest customer with AT LEAST 1 purchase order
I need to write a query to find the youngest customer who bought atleast 1 product
Here is the data:
CUSTOMER:
ORDER_DETAIL:
This is my query so far:
SELECT c.CUSTOMERID, c.age, c.name
from (
SELECT CUSTOMERID, COUNT(ORDERID) as "totalOrder"
FROM…
user4628567
-1
votes
1 answer
Grouping using analytical functions in Oracle
I've got a table with the columns:
col1 (primary key) number
col2 number - contains few duplicates
This table contains 600 records. I'm trying to construct a query where the user can give any group count (max no of records in a group. Eg: 11).…
ragav
- 66
- 7
-3
votes
1 answer
Solve linear inequalities in Julia?
As can't post a post here, so I modified this post to ask a new question. Hope you will not get confused.
Here are inqualities, but how to solve it in Julia:
x+y+z=8
x+y=5
x<6
y>7
Is there a way to get their analytical solution?
Y. zeng
- 121
- 7