Rhonan Carneiro rhonan

## GitCommitEmoji.md

      
              1 file
            
          
              737 forks
            
          
              375 comments
            
          
              3634 stars
            
          
                parmentf
                / GitCommitEmoji.md
            
            
              Last active
              July 8, 2024 09:12
            
              
                Git Commit message Emoji
              
          
    Inspired by dannyfritz/commit-message-emoji
See also gitmoji.


Commit type
Emoji


Initial commit
🎉 :tada:


Version tag
🔖 :bookmark:


New feature
✨ :sparkles:


Bugfix
🐛 :bug:


## rownum.sql
-- http://stackoverflow.com/questions/1124603/grouped-limit-in-postgresql-show-the-first-n-rows-for-each-group
-- http://www.postgresql.jp/document/9.2/html/tutorial-window.html

CREATE TABLE empsalary (
  depname varchar(10) not null
  , empno integer not null
  , salary integer not null
);

INSERT INTO empsalary (depname, empno, salary) VALUES ('develop', 11, 5200);
Commit type	Emoji
Initial commit	🎉 `:tada:`
Version tag	🔖 `:bookmark:`
New feature	✨ `:sparkles:`
Bugfix	🐛 `:bug:`
	-- http://stackoverflow.com/questions/1124603/grouped-limit-in-postgresql-show-the-first-n-rows-for-each-group
	-- http://www.postgresql.jp/document/9.2/html/tutorial-window.html

	CREATE TABLE empsalary (
	depname varchar(10) not null
	, empno integer not null
	, salary integer not null
	);

	INSERT INTO empsalary (depname, empno, salary) VALUES ('develop', 11, 5200);