tiny g(有的话可以推荐一下)

tiny g，有的话可以推荐一下？

这里是喜爱游戏的小白

又到了晒游戏的时间了，小白必须掏出珍藏的单机游戏与大家分享了。小白酷爱单机游戏，主要是单机游戏黏性较弱，游戏时间自由，并且不需氪金，每天想玩的时候玩，不想玩就可以搁置，不会耽误工作和学习。要说好玩的单机游戏，那可以说是太多太多了，从以创意为卖点的小型独立游戏，到以品质为卖点的3A级别大作，可以说每种类型的游戏都数不尽的好游戏，那么今天小白就给大家随便推荐几款比较好玩的单机游戏。

tiny g(有的话可以推荐一下)

《光轮计划》

《光轮计划(Project Nimbus)》是GameCrafterTeam制作的一款机甲飞行射击游戏。这是一款非常炫酷的机甲动作射击游戏，当小白发现这款游戏的时候简直觉得热血沸腾啊。炫酷的机甲，充满了科幻色彩的钢铁之躯，满满的高达既视感，相信没有男生可以拒绝这样的诱惑吧。游戏的操作手感整体良好，各种反转加速动作连贯一气呵成，射击操作简单，带有辅助瞄准系统，射击苦手也不会难玩，除了远程攻击，近战攻击必然少不了的，游戏还专门为近战配备了子弹时间，挥舞手中的斩舰刀将敌人肢解吧～当你驾驶机甲在天空中翱翔的那一刻，就会有一种整个世界都被你征服的快感。

《迷你金属》

《迷你金属(TINY METAL)》是由AREA 35制作Sony Music Entertainment发行的一款回合制策略游戏，这是一款现代战争背景下的回合制战棋策略游戏。本作号称“高级战争”的精神续作，从各个方面都可以看到“高级战争”的影子，各具特色的兵种，不同风格的指挥官，超强的英雄单位，可升级的精英单位，还有兵种克制、朝向、集火、战争迷雾等内容，可以说是元素丰富玩法齐全。如果是玩过当年“高级战争”的玩家上手会非常顺利，但是相比之下，本作除了画面更加优秀之外，在游戏层面上还达不到“高级战争”的高度。

《接管》

《接管(The TakeOver)》是一款由pelikan13制作并发行的动作冒险类游戏，是向上世纪街机动作游戏《快打旋风》以及《怒之铁拳》致敬的作品。这是一款复古的街机动作游戏，该游戏中玩家将可以控制不同的角色进行战斗，每个角色都有各自的特点。在战斗中除了通过基本的拳击，踢打动作来和敌人缠斗之外，一些特殊的攻击技能配合连击动作将可以对敌人造成更多伤害。游戏的手感不错，出招有一些僵直，不知道是不是刻意对街机游戏的模仿。其他方面感觉还好，主要是画面比较优秀，打击感也不错。

以上就是小白这次带来的几款比较好玩的单机游戏推荐啦~

这里是喜爱游戏的小白，欢迎大家关注小白，小白会推荐好玩的游戏给大家哦~

韩国女团成员身高低于160有哪些人？

Tiny-G组合（三位成员都是150左右）

宇宙少女Luda（156）

lovelyz李秀景（158）

Red Velvet 金艺琳（155）

T-ara全宝蓝（155）

Red Velvet裴珠泫（157）

求一些比较简单有趣的英语绕口令？

A big black bug bit a big black bear, made the big black bear bleed blood. A big black bug bit a big black bear. Where's the big black bear the big black bug bit? A bitter biting bittern bit a better brother bittern, and the bitter better bittern bit the bitter biter back. And the bitter bittern, bitten, by the better bitten bittern, said: "I'm a bitter biter bit, alack!" A bloke's back bike brake block broke. A box of biscuits, a batch of mixed biscuits. A flea and a fly flew up in a flue. Said the flea, "Let us fly!" Said the fly, "Let us flee!" So they flew through a flaw in the flue. A flea and a fly were trapped in a flue, and they tried to flee for their life. The flea said to the fly "Let's flee!" and the fly said to the flea "Let's fly!" Finally both the flea and fly managed to flee through a flaw in the flue. A laurel-crowned clown! A lusty lady loved a lawyer and longed to lure him from his laboratory. A noisy noise annoys an oyster. A pleasant place to place a plaice is a place where a plaice is pleased to be placed. A skunk sat on a stump and thunk the stump stunk,but the stump thunk the skunk stunk. A tidy tiger tied a tie tighter to tidy her tiny tail. A tree toad loved a she-toad who lived up in a tree. He was a two-toed tree toad but a three-toed toad was she. The two-toed tree toad tried to win the three-toed she-toad's heart, for the two-toed tree toad loved the ground that the three-toed tree toad trod. But the two-toed tree toad tried in vain. He couldn't please her whim. From her tree toad bower with her three-toed power the she-toad vetoed him. A tutor who tooted a flute tried to tutor two tooters to toot. Said the two to their tutor, "Is it harder to toot or to tutor two tooters to toot?" All I want is a proper cup of coffee made in a proper copper coffee pot, you can believe it or not, but I just want a cup of coffee in a proper coffee pot. Tin coffee pots or iron coffee pots are of no use to me. If I can't have a proper cup of coffee in a proper copper coffee pot, I'll have a cup of tea! Amidst the mists and coldest frosts, with stoutest wrists and loudest boasts, he thrusts his fist against the posts and still insists he sees the ghosts. Are our oars oak? A Finnish fisher named Fisher failed to fish any fish one Friday afternoon and finally he found out a big fissure in his fishing-net. A snow-white swan swiftly to catch a slowly-swimming snake in a lake. A writer named Wright was instructing his little son how to write Wright right. He said: "It is not right to write Wright as 'rite'---try to write Wright aright!"A tall eastern girl named Short long loved a big Mr. Little. But Little, thinking little of Short, loved a little lass named Long. To belittle Long. Short announced She would marry Little before long. This caused Little shortly to marry Long. To make a long story short, did tall Short love big Little less because Little loved little Long more? B Betty and Bob brought back blue balloons from the big bazaar. Betty beat a bit of butter to make a better batter. Betty better butter Brad's bread. Black bugs' blood. Brad's big black bath brush broke. Bright blows the broom on the brook's bare brown banks. Brisk brave brigadiers brandished broad bright blades, blunderbusses, and bludgeons - balancing them badly. Betty Botter had some butter, "But," she said, "this butter's bitter. If I bake this bitter butter, it would make my batter bitter. But a bit of better butter -- that would make my batter better." Bob bought a big bag of buns to bait the bears' babies. Bill's big brother is building a beautiful building between two big brick blocks.C. Can you imagine an imaginary menagerie manager imagining managing an imaginary menagerie? Cedar shingles should be shaved and saved. Cheap ship trip. Cheryl's chilly cheap chip shop sells Cheryl's cheap chips. Chop shops stock chops. Crisp crusts crackle crunchily. D. Diligence dismisseth despondency. Don't pamper damp scamp tramps that camp under ramp lamps. Double bubble gum bubbles double. Dust is a disk's worst enemy. E. Ed had edited it. F. Flash message! Flee from fog to fight flu fast. Fred fed Ted bread, and Ted fed Fred bread. Freshly fried fresh flesh. Freshly-fried flying fish. Friendly Frank flips fine flapjacks. Fuzzy wuzzy was a bear. Fuzzy wuzzy had no hair. Fuzzy wuzzy wasn't fuzzy. Was he?G. Gertie's great-grandma grew aghast at Gertie's grammar. Girl gargoyle, guy gargoyle. Give me the gift of a grip top sock: a drip-drape, ship-shape, tip-top sock. Give Mr. Snipa's wife's knife a swipe. Give papa a cup of proper coffee in a copper coffee cup. Good blood, bad blood. Greek grapes. H. He thrusts his fists against the posts and still insists he sees the ghosts. How much wood would a woodchuck chuck if a woodchuck could chuck wood? He would chuck, he would, as much as he could, and chuck as much wood as a woodchuck would if a woodchuck could chuck wood. I. I am not the pheasant plucker, I'm the pheasant plucker's mate. I am only plucking pheasants 'cause the pheasant plucker's running late. I cannot bear to see a bear bear down upon a hare. When bare of hair he strips the hare, Right there I cry, "Forbear!" I correctly recollect Rebecca MacGregor's reckoning. I saw Esau kissing Kate. I saw Esau, he saw me, and she saw I saw Esau. I slit a sheet, a sheet I slit. Upon the slitted sheet, I sit. I thought a thought. But the thought I thought wasn't the thought I thought I thought. I wish you were a fish in my dish. If Stu chews shoes, should Stu choose the shoes he chews? If you notice this notice you will notice that this notice is not worth noticing. If a shipshape ship shop stocks six shipshape shop-soiled ships, how many shipshape shop-soiled ships would six shipshape ship shops stock? Irish wristwatch. Is there a pleasant peasant present? Is this your sister's sixth zither, sir? J. Just think, that sphinx has a sphincter that stinks! K. Knapsack straps. Knife and a fork, bottle and a cork, that is the way you spell New York. L. Lily ladles little Letty's lentil soup. Listen to the local yokel yodel. Lovely lemon liniment. M. Meet Sir Cecil Thistlethwaite, the celebrated theological statistician. Mix, Miss Mix! Moose noshing much mush. Moses supposes his toeses are roses, but moses supposes erroneously. For moses, he knowses his toeses aren't roses as moses supposes his toeses to be! Mrs. Smith's Fish Sauce Shop. My dame hath a lame tame crane. My dame hath a crane that is lame. Mr. Cook said to a cook: "Look at this cook-book. It's very good." So the cook took the advice of Mr. Cook and bought the book.N. Nine nice night nurses nursing nicely. O. Of all the felt I ever felt, I never felt a piece of felt which felt as fine as that felt felt, when first I felt that felt hat's felt. Old oily Ollie oils old oily autos. Once upon a barren moor there dwelt a bear, also a boar. The bear could not bear the boar. The boar thought the bear a bore. At last the bear could bear no more of that boar that bored him on the moor, and so one morn he bored the boar - that boar will bore the bear no more. One smart fellow, he felt smart. Two smart fellows, they felt smart. Three smart fellows, they all felt smart. One-One was a racehorse. Two-Two was one, too. When One-One won one race, Two-Two won one, too. P. Pacific Lithograph. Peggy Babcock. Plague-bearing prairie dogs. Please pay promptly. Peter Piper picked a peck of pickled pepper prepared by his parents and put them in a big paper plate. Peter Piper picked a peck of pickled

peppers.Did

Peter Piper pick a peck of pickled peppers?If Peter Piper picked a peck of pickled peppers,where's the peck of pickled peppers Peter Piper picked? Q. Quick kiss. Quicker kiss. R. Real weird rear wheels. Red lorry, yellow lorry, red lorry, yellow lorry. Robin Redbreast's bad breath. S. Sam's shop stocks short spotted socks. Sarah sitting in her sitting room, all she does is sits and shifts, all she does is sits and shifts. Say this sharply, say this sweetly, Say this shortly, say this softly. Say this sixteen times in succession. Selfish shellfish. She said she should sit. She sees cheese. She sells seashells by the sea shore. The shells she sells are surely seashells. So if she sells shells on the seashore, I'm sure she sells seashore shells. She sifted thistles through her thistle-sifter. Sheep shouldn't sleep in a shack. Sheep should sleep in a shed. Shelter for six sick scenic sightseers. Shredded Swiss cheese. Shy Shelly says she shall sew sheets. Silly Sally swiftly shooed seven silly sheep. The seven silly sheep Silly Sally shooed shilly-shallied south. These sheep shouldn't sleep in a shack; sheep should sleep in a shed. Silly sheep weep and sleep. Six sharp smart sharks. Six shimmering sharks' sharply striking shins. Six short slow shepherds. Six silly sisters sell silk to six sickly senior

citizens.Six

slippery snails, slid slowly seaward. Six sticky sucker sticks. Six twin screwed steel steam cruisers. Six thick thistle sticks. Six thick thistles stick. "Surely Sylvia swims!" shrieked Sammy, surprised. "Someone should show Sylvia some strokes so she shall not sink."So she bought a bit of butter,better than her bitter butter,and she baked it in her batter,and the batter was not

bitter.So

'twas better Betty Botterbought a bit of better butter. T. Thank the other three brothers of their father's mother's brother's side. The blue bluebird blinks. The cat catchers can't catch caught cats. The crow flew over the river with a lump of raw liver. The epitome of femininity. The sixth sick sheik's sixth sheep's sick. The soldiers shouldered shooters on their shoulders. The sun shines on shop signs. The two-twenty-two train tore through the tunnel. There was cinnamon in the aluminum pan. Thieves seize skis. Three gray geese in the green grass grazing. Gray were the geese and green was the grass. Tim, the thin twin tinsmith. Tiny orangutan tongues! Toy boat. Toy boat. Toy boat. Tragedy strategy. U. Unique New York. ???? Urgent detergent! W. We surely shall see the sun shine soon. Which wristwatches are Swiss wristwatches? While we were walking, we were watching window washers wash Washington's windows with warm washing water. Who washed Washington's white woollen underwear when Washington's washer woman went west? Will you, William? Where is the watch I put in my pocket to take to the shop because it had stopped? You sent me your bill, Berry, Before it was due, Berry; Your father, the elder Berry, Isn't such a goose, Berry.

如何使用MySQL中的实用函数及查询技巧？

一直以来，MySQL 只有针对聚合函数的汇总类功能，比如MAX, AVG 等，没有从 SQL 层针对聚合类每组展开处理的功能。不过 MySQL 开放了 UDF 接口，可以用 C 来自己写UDF，这个就增加了功能行难度。

这种针对每组展开处理的功能就叫窗口函数，有的数据库叫分析函数。

在 MySQL 8.0 之前，我们想要得到这样的结果，就得用以下几种方法来实现：

1. session 变量

2. group_concat 函数组合

3. 自己写 store routines

接下来我们用经典的学生/课程/成绩来做窗口函数演示

准备

学生表

mysql> show create table student \G*************************** 1. row ***************************Table: studentCreate Table: CREATE TABLE student (sid int(10) unsigned NOT NULL,sname varchar(64) DEFAULT NULL,PRIMARY KEY (sid)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci1 row in set (0.00 sec)

课程表

mysql> show create table course\G*************************** 1. row ***************************Table: courseCreate Table: CREATE TABLE `course` (`cid` int(10) unsigned NOT NULL,`cname` varchar(64) DEFAULT NULL,PRIMARY KEY (`cid`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci1 row in set (0.00 sec)

成绩表

mysql> show create table score\G*************************** 1. row ***************************Table: scoreCreate Table: CREATE TABLE `score` (`sid` int(10) unsigned NOT NULL,`cid` int(10) unsigned NOT NULL,`score` tinyint(3) unsigned DEFAULT NULL,PRIMARY KEY (`sid`,`cid`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci1 row in set (0.00 sec)

测试数据

mysql> select * from student;+-----------+--------------+| sid | sname |+-----------+--------------+| 201910001 | 张三 || 201910002 | 李四 || 201910003 | 武松 || 201910004 | 潘金莲 || 201910005 | 菠菜 || 201910006 | 杨发财 || 201910007 | 欧阳修 || 201910008 | 郭靖 || 201910009 | 黄蓉 || 201910010 | 东方不败 |+-----------+--------------+10 rows in set (0.00 sec)mysql> select * from score;;+-----------+----------+-------+| sid | cid | score |+-----------+----------+-------+| 201910001 | 20192001 | 50 || 201910001 | 20192002 | 88 || 201910001 | 20192003 | 54 || 201910001 | 20192004 | 43 || 201910001 | 20192005 | 89 || 201910002 | 20192001 | 79 || 201910002 | 20192002 | 97 || 201910002 | 20192003 | 82 || 201910002 | 20192004 | 85 || 201910002 | 20192005 | 80 || 201910003 | 20192001 | 48 || 201910003 | 20192002 | 98 || 201910003 | 20192003 | 47 || 201910003 | 20192004 | 41 || 201910003 | 20192005 | 34 || 201910004 | 20192001 | 81 || 201910004 | 20192002 | 69 || 201910004 | 20192003 | 67 || 201910004 | 20192004 | 99 || 201910004 | 20192005 | 61 || 201910005 | 20192001 | 40 || 201910005 | 20192002 | 52 || 201910005 | 20192003 | 39 || 201910005 | 20192004 | 74 || 201910005 | 20192005 | 86 || 201910006 | 20192001 | 42 || 201910006 | 20192002 | 52 || 201910006 | 20192003 | 36 || 201910006 | 20192004 | 58 || 201910006 | 20192005 | 84 || 201910007 | 20192001 | 79 || 201910007 | 20192002 | 43 || 201910007 | 20192003 | 79 || 201910007 | 20192004 | 98 || 201910007 | 20192005 | 88 || 201910008 | 20192001 | 45 || 201910008 | 20192002 | 65 || 201910008 | 20192003 | 90 || 201910008 | 20192004 | 89 || 201910008 | 20192005 | 74 || 201910009 | 20192001 | 73 || 201910009 | 20192002 | 42 || 201910009 | 20192003 | 95 || 201910009 | 20192004 | 46 || 201910009 | 20192005 | 45 || 201910010 | 20192001 | 58 || 201910010 | 20192002 | 52 || 201910010 | 20192003 | 55 || 201910010 | 20192004 | 87 || 201910010 | 20192005 | 36 |+-----------+----------+-------+50 rows in set (0.00 sec)mysql> select * from course;+----------+------------+| cid | cname |+----------+------------+| 20192001 | mysql || 20192002 | oracle || 20192003 | postgresql || 20192004 | mongodb || 20192005 | dble |+----------+------------+5 rows in set (0.00 sec)

MySQL 8.0 之前

比如我们求成绩排名前三的学生排名，我来举个用 session 变量和 group_concat 函数来分别实现的例子：

session 变量方式

每组开始赋一个初始值序号和初始分组字段。

SELECTb.cname,a.sname,c.score, c.ranking_scoreFROMstudent a,course b,(SELECTc.*,IF(@cid = c.cid,@rn := @rn + 1,@rn := 1) AS ranking_score,@cid := c.cid AS tmpcidFROM(SELECT*FROMscoreORDER BY cid,score DESC) c,(SELECT@rn := 0 rn,@cid := '') initialize_table) cWHERE a.sid = c.sidAND b.cid = c.cidAND c.ranking_score <= 3ORDER BY b.cname,c.ranking_score;+------------+-----------+-------+---------------+| cname | sname | score | ranking_score |+------------+-----------+-------+---------------+| dble | 张三 | 89 | 1 || dble | 欧阳修 | 88 | 2 || dble | 菠菜 | 86 | 3 || mongodb | 潘金莲 | 99 | 1 || mongodb | 欧阳修 | 98 | 2 || mongodb | 郭靖 | 89 | 3 || mysql | 李四 | 100 | 1 || mysql | 潘金莲 | 81 | 2 || mysql | 欧阳修 | 79 | 3 || oracle | 武松 | 98 | 1 || oracle | 李四 | 97 | 2 || oracle | 张三 | 88 | 3 || postgresql | 黄蓉 | 95 | 1 || postgresql | 郭靖 | 90 | 2 || postgresql | 李四 | 82 | 3 |+------------+-----------+-------+---------------+15 rows in set, 5 warnings (0.01 sec)

group_concat 函数方式

利用 findinset 内置函数来返回下标作为序号使用。

SELECT*FROM(SELECTb.cname,a.sname,c.score,FIND_IN_SET(c.score, d.gp) score_rankingFROMstudent a,course b,score c,(SELECTcid,GROUP_CONCAT(scoreORDER BY score DESC SEPARATOR ',') gpFROMscoreGROUP BY cidORDER BY score DESC) dWHERE a.sid = c.sidAND b.cid = c.cidAND c.cid = d.cidORDER BY d.cid,score_ranking) yttWHERE score_ranking <= 3；+------------+-----------+-------+---------------+| cname | sname | score | score_ranking |+------------+-----------+-------+---------------+| dble | 张三 | 89 | 1 || dble | 欧阳修 | 88 | 2 || dble | 菠菜 | 86 | 3 || mongodb | 潘金莲 | 99 | 1 || mongodb | 欧阳修 | 98 | 2 || mongodb | 郭靖 | 89 | 3 || mysql | 李四 | 100 | 1 || mysql | 潘金莲 | 81 | 2 || mysql | 欧阳修 | 79 | 3 || oracle | 武松 | 98 | 1 || oracle | 李四 | 97 | 2 || oracle | 张三 | 88 | 3 || postgresql | 黄蓉 | 95 | 1 || postgresql | 郭靖 | 90 | 2 || postgresql | 李四 | 82 | 3 |+------------+-----------+-------+---------------+15 rows in set (0.00 sec)

MySQL 8.0 窗口函数

MySQL 8.0 后提供了原生的窗口函数支持，语法和大多数数据库一样，比如还是之前的例子：

用 row_number() over () 直接来检索排名。

mysql>SELECT*FROM(SELECTb.cname,a.sname,c.score,row_number() over (PARTITION BY b.cnameORDER BY c.score DESC) score_rankFROMstudent AS a,course AS b,score AS cWHERE a.sid = c.sidAND b.cid = c.cid) yttWHERE score_rank <= 3;+------------+-----------+-------+------------+| cname | sname | score | score_rank |+------------+-----------+-------+------------+| dble | 张三 | 89 | 1 || dble | 欧阳修 | 88 | 2 || dble | 菠菜 | 86 | 3 || mongodb | 潘金莲 | 99 | 1 || mongodb | 欧阳修 | 98 | 2 || mongodb | 郭靖 | 89 | 3 || mysql | 李四 | 100 | 1 || mysql | 潘金莲 | 81 | 2 || mysql | 欧阳修 | 79 | 3 || oracle | 武松 | 98 | 1 || oracle | 李四 | 97 | 2 || oracle | 张三 | 88 | 3 || postgresql | 黄蓉 | 95 | 1 || postgresql | 郭靖 | 90 | 2 || postgresql | 李四 | 82 | 3 |+------------+-----------+-------+------------+15 rows in set (0.00 sec)

那我们再找出课程 MySQL 和 DBLE 里不及格的倒数前两名学生名单。

mysql>SELECT*FROM(SELECTb.cname,a.sname,c.score,row_number () over (PARTITION BY b.cidORDER BY c.score ASC) score_rankingFROMstudent AS a,course AS b,score AS cWHERE a.sid = c.sidAND b.cid = c.cidAND b.cid IN (20192005, 20192001)AND c.score < 60) yttWHERE score_ranking < 3;+-------+--------------+-------+---------------+| cname | sname | score | score_ranking |+-------+--------------+-------+---------------+| mysql | 菠菜 | 40 | 1 || mysql | 杨发财 | 42 | 2 || dble | 武松 | 34 | 1 || dble | 东方不败 | 36 | 2 |+-------+--------------+-------+---------------+4 rows in set (0.00 sec)

到此为止，我们只是演示了row_number() over() 函数的使用方法，其他的函数有兴趣的朋友可以自己体验体验，方法都差不多。