Skip to content

Instantly share code, notes, and snippets.

View jianhe-fun's full-sized avatar
🏠
Working from home

jianhe jianhe-fun

🏠
Working from home
View GitHub Profile
@jianhe-fun
jianhe-fun / index.html
Created August 15, 2021 16:27
gist for owner index html
<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<h1 style="text-align: center;" th:text="'List Of all Owner'">List of owner.</h1>
<table>
<thead>
@jianhe-fun
jianhe-fun / WindowFunction
Last active December 13, 2021 12:10
WindowsFunction
select * from emp; -- show the whole table.
begin;
create table emp(empid int primary key, name text, department text, salary numeric);
insert into emp(empid, name, department, salary) values
(7,'Carol','Sales',4600.00),
(8,'sean','Sales',5600.00),
(1,'Cowen','Shipping',5400.00),
(2,'Tyler','Marketing',6300.00),
(5,'Charles','Sales',5400.00),