Skip to content

Instantly share code, notes, and snippets.

+------------+-----------------+---------------------------+ | Category | Product Name | Product Description | +------------+-----------------+---------------------------+ | Casual | Black Shoe | This is a shoe | | Electronic | Washing Machine | This is a washing machine | | Electronic | TV | This is a tv | | Casual | Blue Trousers | This is trousers | | Casual | White Shoe | This is a shoe | | Casual | Blue Shoe | This is a shoe | +------------+-----------------+---------------------------+

select
user_id,
LAST_VALUE(location)over w,
event_time
from my_users
window as (
user_id by category
order by event_time
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
)
select
user_id,
LAST_VALUE(location)over w,
event_time
from my_users
window as (
user_id by category
order by event_time
RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
)
select
user_id,
LAST_VALUE(location)over w,
event_time
from my_users
window as (user_id by category order by event_time)
import java.util.*;
public class MyTest {
private static int shortestPath(int[] from, int[] to, int source, int destination) {
Map<Integer, Set<Integer>> graph = getGraph(from, to);
return iterate(graph, new HashSet<>(), source, destination);
}
@javrasya
javrasya / get_latest_git_tag_by_pattern.bash
Created January 20, 2017 15:13
Get latest git tag by a version pattern
echo "$(git tag --sort=committerdate | grep -o 'v[0-9]*\.[0-9]*\.[0-9]*' | tail -n1)"
SELECT
[Maliyet Detayları].[CR Numarası],
[Maliyet Detayları].[Toplam Adam],
[Versiyon İçerikleri].[Ana Versiyon],
[Versiyon İçerikleri].[Versiyon Numarası],
[Uygulama Versiyonları].[Uygulama Adı],
[Maliyet Detayları].[İlgili Domain]
FROM [Uygulama Versiyonları]
INNER JOIN (
[Versiyon İçerikleri]
<div class="action-wizard" xmlns="http://www.w3.org/1999/html">
<div class="hero">
<div class="container">
<h3>{{ 'esefcontent_add_header'|translate: {model:modelName} }}</h3>
</div>
</div>
<div class="panel container">
<div class="panel-body">
<form name="actionForm" ng-submit="saveAction(true)">
<div class="action-wizard" xmlns="http://www.w3.org/1999/html">
<div class="hero">
<div class="container">
<h3>{{ 'esefcontent_add_header'|translate: {model:modelName} }}</h3>
</div>
</div>
<div class="panel container">
<div class="panel-body">
<form name="actionForm" ng-submit="saveAction(true)">
__author__ = 'ahmetdal'