2019-10-17

50道SQL練習題

來自http://www.reibang.com/p/476b52ee4f1b

sql語句的執(zhí)行順序

（9）Select
（10）distinct 字段名1,字段名2掺炭，
（7）[fun(字段名)]
（1）from 表1
（3）<join類型>join 表2
（2）on <join條件>
（4）where <where條件>
（5）group by <字段>
（6）with <cube|rollup>
（8）having <having條件>
（11）order by <排序字段>
（12）limit <起始偏移量,行數(shù)>

學生表 Student

create table Student(SId varchar(10),Sname varchar(10),Sage datetime,Ssex varchar(10));
insert into Student values('01' , '趙雷' , '1990-01-01' , '男');
insert into Student values('02' , '錢電' , '1990-12-21' , '男');
insert into Student values('03' , '孫風' , '1990-12-20' , '男');
insert into Student values('04' , '李云' , '1990-12-06' , '男');
insert into Student values('05' , '周梅' , '1991-12-01' , '女');
insert into Student values('06' , '吳蘭' , '1992-01-01' , '女');
insert into Student values('07' , '鄭竹' , '1989-01-01' , '女');
insert into Student values('09' , '張三' , '2017-12-20' , '女');
insert into Student values('10' , '李四' , '2017-12-25' , '女');
insert into Student values('11' , '李四' , '2012-06-06' , '女');
insert into Student values('12' , '趙六' , '2013-06-13' , '女');
insert into Student values('13' , '孫七' , '2014-06-01' , '女');

科目表 Course

create table Course(CId varchar(10),Cname nvarchar(10),TId varchar(10));
insert into Course values('01' , '語文' , '02');
insert into Course values('02' , '數(shù)學' , '01');
insert into Course values('03' , '英語' , '03');

教師表 Teacher

create table Teacher(TId varchar(10),Tname varchar(10));
insert into Teacher values('01' , '張三');
insert into Teacher values('02' , '李四');
insert into Teacher values('03' , '王五');

成績表 SC

create table SC(SId varchar(10),CId varchar(10),score decimal(18,1));
insert into SC values('01' , '01' , 80);
insert into SC values('01' , '02' , 90);
insert into SC values('01' , '03' , 99);
insert into SC values('02' , '01' , 70);
insert into SC values('02' , '02' , 60);
insert into SC values('02' , '03' , 80);
insert into SC values('03' , '01' , 80);
insert into SC values('03' , '02' , 80);
insert into SC values('03' , '03' , 80);
insert into SC values('04' , '01' , 50);
insert into SC values('04' , '02' , 30);
insert into SC values('04' , '03' , 20);
insert into SC values('05' , '01' , 76);
insert into SC values('05' , '02' , 87);
insert into SC values('06' , '01' , 31);
insert into SC values('06' , '03' , 34);
insert into SC values('07' , '02' , 89);
insert into SC values('07' , '03' , 98);
1.查詢" 01 "課程比" 02 "課程成績高的學生的信息及課程分數(shù)
SELECT
    * 
FROM
    Student s 
WHERE
    s.SId IN (
    SELECT
        sc1.SId 
    FROM
        SC sc1
        JOIN SC sc2 ON sc1.SId = sc2.SId 
        AND sc1.CId = '01' 
        AND sc2.CId = '02' 
    AND sc1.score > sc2.score 
    );
2.查詢同時存在" 01 "課程和" 02 "課程的學生情況
SELECT
    * 
FROM
    Student s 
WHERE
    s.SId IN (
    SELECT
        sc1.SId 
    FROM
        SC sc1
        JOIN SC sc2 ON sc1.CId = '01' 
        AND sc2.CId = '02' 
    AND sc1.SId = sc2.SId 
    );
3.查詢存在" 01 "課程但不存在" 02 "課程的學生情況(不存在時顯示為 null )
SELECT
    * 
FROM
    Student s 
WHERE
    s.SId IN (
    SELECT
        sc1.SId 
    FROM
        ( SELECT * FROM SC WHERE SC.CId = '01' ) AS sc1
        LEFT JOIN ( SELECT * FROM SC WHERE SC.CId = '02' ) AS sc2 ON sc1.SId = sc2.SId 
    WHERE
    sc2.SId IS NULL 
    );
4.查詢不存在" 01 "課程但存在" 02 "課程的學生情況
SELECT
    s.* 
FROM
    Student s,
    (
    SELECT
        sc2.SId 
    FROM
        ( SELECT * FROM SC WHERE SC.CId = '01' ) AS sc1
        RIGHT JOIN ( SELECT * FROM SC WHERE SC.CId = '02' ) AS sc2 ON sc1.SId = sc2.SId 
    WHERE
        sc1.SId IS NULL 
    ) AS sc2id 
WHERE
    s.SId = sc2id.SId;
5.查詢平均成績大于等于 60 分的同學的學生編號和學生姓名和平均成績
SELECT
    s.SId,
    s.Sname,
    avgs1.as1 
FROM
    Student s,
    ( SELECT SId, AVG( score ) AS as1 FROM SC GROUP BY SId HAVING AVG( score ) > 60 ) AS avgs1 
WHERE
    s.SId = avgs1.SId;
6.查詢在 SC 表存在成績的學生信息
SELECT DISTINCT
    s.* 
FROM
    Student s,
    SC 
WHERE
    s.SId = SC.SId;
7.查詢所有同學的學生編號姑原、學生姓名、選課總數(shù)临庇、所有課程的成績總和
SELECT
    s.SId,
    s.Sname,
    sccs.scc,
    sccs.scs 
FROM
    Student s
    LEFT JOIN (
    SELECT
        SC.SId,
        COUNT( SC.CId ) AS scc,
        SUM( SC.score ) AS scs 
    FROM
        SC 
    GROUP BY
    SC.SId 
    ) AS sccs ON s.SId = sccs.SId;
8.查有成績的學生信息
SELECT
    * 
FROM
    Student s 
WHERE
    EXISTS ( SELECT SC.SId FROM SC WHERE SC.SId = s.SId );
9.查詢「李」姓老師的數(shù)量
SELECT
    COUNT( * ) 
FROM
    Teacher 
WHERE
    Tname LIKE '李%';
10.查詢學過「張三」老師授課的同學的信息
SELECT
    s.* 
FROM
    Teacher t,
    Course c,
    SC,
    Student s 
WHERE
    t.Tname = '張三' 
    AND t.TId = c.TId 
    AND SC.CId = c.CId 
    AND s.SId = SC.SId;
11.查詢沒有學全所有課程的同學的信息
SELECT
    * 
FROM
    Student s 
WHERE
    s.SId NOT IN (
    SELECT
        SC.SId 
    FROM
        SC 
    GROUP BY
        SC.SId 
    HAVING
    COUNT( SC.CId ) = ( SELECT COUNT( c.CId ) FROM Course c ) 
    );
12.查詢至少有一門課與學號為" 01 "的同學所學相同的同學的信息
SELECT DISTINCT
    s.* 
FROM
    ( SELECT * FROM SC WHERE SC.SId = '01' ) AS sc1
    JOIN ( SELECT * FROM SC WHERE SC.SId != '01' ) AS sc2
    JOIN Student s 
WHERE
    sc1.CId = sc2.CId 
    AND s.SId = sc2.SId;
13.查詢和" 01 "號的同學學習的課程完全相同的其他同學的信息
SELECT
    SId 
FROM
    SC 
WHERE
    CId IN ( SELECT SC.CId FROM SC WHERE SC.SId = '01' ) 
GROUP BY
    SC.SId 
HAVING
    COUNT( * ) = ( SELECT COUNT( * ) FROM SC WHERE SC.SId = '01' ) 
    AND SC.SId != '01';

但是如果SId='02'增加一條CId='04',按照上面的語句也是符合條件。因為第三行的語句把這種CId='04'給過濾了昵慌。

SELECT
    * 
FROM
    Student 
WHERE
    SId IN (
    SELECT
        SId 
    FROM
        SC 
    GROUP BY
        SId 
    HAVING
        GROUP_CONCAT( CId ) = ( SELECT GROUP_CONCAT( CId ) FROM SC WHERE SId = '01' ) 
    AND SId != '01' 
    );
14.查詢沒學過"張三"老師講授的任一門課程的學生姓名
SELECT
    s.SName 
FROM
    Student s 
WHERE
    s.SId NOT IN (
    SELECT
        SC.SId 
    FROM
        Teacher t,
        Course c,
        SC 
    WHERE
        t.Tname = '張三' 
        AND t.TId = c.TId 
    AND SC.CId = c.CId 
    );
15.查詢兩門及其以上不及格課程的同學的學號假夺，姓名及其平均成績
SELECT
    s.SId,
    s.Sname,
    AVG( SC.score ) 
FROM
    SC,
    Student s 
WHERE
    s.SId = SC.SId 
    AND SC.score < 60 GROUP BY SC.SId HAVING COUNT( * ) > 1;
16.檢索" 01 "課程分數(shù)小于 60，按分數(shù)降序排列的學生信息
SELECT
    s.*,
    SC.score 
FROM
    SC,
    Student s 
WHERE
    SC.CId = '01' 
    AND SC.score < 60 
    AND SC.SId = s.SId 
ORDER BY
    SC.score DESC;
17.按平均成績從高到低顯示所有學生的所有課程的成績以及平均成績
SELECT
    SC.*,
    sc1.avgs 
FROM
    SC
    LEFT JOIN ( SELECT SId, AVG( SC.score ) AS avgs FROM SC GROUP BY SId ) AS sc1 ON SC.SId = sc1.SId 
ORDER BY
    sc1.avgs DESC;
18.查詢各科成績最高分斋攀、最低分和平均分:

以如下形式顯示：課程 ID已卷，課程 name，最高分淳蔼，最低分侧蘸，平均分裁眯，及格率，中等率讳癌，優(yōu)良率穿稳，優(yōu)秀率
及格為>=60，中等為：70-80晌坤，優(yōu)良為：80-90逢艘，優(yōu)秀為：>=90
要求輸出課程號和選修人數(shù)，查詢結(jié)果按人數(shù)降序排列骤菠，若人數(shù)相同埋虹，按課程號升序排列

SELECT
    SC.CId,
    c.Cname,
    MAX( SC.score ) AS tops,
    MIN( SC.score ) AS lows,
    AVG( SC.score ) AS avgs,
    COUNT( * ) AS nump,
    SUM( CASE WHEN SC.score >= 60 THEN 1 ELSE 0 END ) / COUNT( * ) AS pasr,
    SUM( CASE WHEN SC.score >= 70 AND SC.score < 80 THEN 1 ELSE 0 END ) / COUNT( * ) AS medr,
    SUM( CASE WHEN SC.score >= 90 THEN 1 ELSE 0 END ) / COUNT( * ) AS excr 
FROM
    SC,
    Course c 
WHERE
    SC.CId = c.CId 
GROUP BY
    SC.CId 
ORDER BY
    COUNT( * ) DESC,
    SC.CId ASC;
19.按各科成績進行排序，并顯示排名娩怎， Score 重復(fù)時保留名次空缺
SELECT
    sc1.CId,
    sc1.SId,
    COUNT( sc2.score ) + 1 rank 
FROM
    SC sc1
    LEFT JOIN SC sc2 ON sc1.CId = sc2.CId 
    AND sc1.score < sc2.score 
GROUP BY
    sc1.CId,
    sc1.SId 
ORDER BY
    sc1.CId,
    rank;
查詢學生的總成績搔课，并進行排名，總分重復(fù)時不保留名次空缺
SET @rank := 0;
SELECT
    sc.SId,
    total,
    @rank := @rank + 1 AS Rank 
FROM
    ( SELECT SC.SId, SUM( SC.score ) AS total FROM SC GROUP BY SC.SId ORDER BY total DESC ) sc;
20.統(tǒng)計各科成績各分數(shù)段人數(shù)：課程編號截亦，課程名稱爬泥，[100-85]，[85-70]崩瓤，[70-60]袍啡，[60-0] 及所占百分比
SELECT
    Course.CId,
    Course.Cname,
    p1.`[100-85]`,
    p1.`[100-85]%`,
    p2.`[85-70]`,
    p2.`[85-70]%`,
    p3.`[70-60]`,
    p3.`[70-60]%`,
    p4.`[60-0]`,
    p4.`[60-0]%` 
FROM
    Course
    LEFT JOIN (
    SELECT
        CId,
        SUM( CASE WHEN SC.score <= 100 AND SC.score > 85 THEN 1 ELSE 0 END ) AS `[100-85]`,
        ROUND(
            (
                SUM( CASE WHEN SC.score <= 100 AND SC.score > 85 THEN 1 ELSE 0 END ) * 100 / COUNT( * ) 
            ),
            2 
        ) `[100-85]%` 
    FROM
        SC 
    GROUP BY
        SC.CId 
    ) p1 ON Course.CId = p1.CId
    LEFT JOIN (
    SELECT
        CId,
        SUM( CASE WHEN SC.score <= 85 AND SC.score > 70 THEN 1 ELSE 0 END ) AS `[85-70]`,
        ROUND(
            (
                SUM( CASE WHEN SC.score <= 85 AND SC.score > 70 THEN 1 ELSE 0 END ) * 100 / COUNT( * ) 
            ),
            2 
        ) AS `[85-70]%` 
    FROM
        SC 
    GROUP BY
        SC.CId 
    ) AS p2 ON Course.CId = p2.CId
    LEFT JOIN (
    SELECT
        CId,
        SUM( CASE WHEN SC.score <= 70 AND SC.score > 60 THEN 1 ELSE 0 END ) AS `[70-60]`,
        ROUND(
            (
                SUM( CASE WHEN SC.score <= 70 AND SC.score > 60 THEN 1 ELSE 0 END ) * 100 / COUNT( * ) 
            ),
            2 
        ) AS `[70-60]%` 
    FROM
        SC 
    GROUP BY
        SC.CId 
    ) AS p3 ON Course.CId = p3.CId
    LEFT JOIN (
    SELECT
        CId,
        SUM( CASE WHEN SC.score <= 60 AND SC.score > 0 THEN 1 ELSE 0 END ) AS `[60-0]`,
        ROUND(
            (
                SUM( CASE WHEN SC.score <= 60 AND SC.score > 0 THEN 1 ELSE 0 END ) * 100 / COUNT( * ) 
            ),
            2 
        ) AS `[60-0]%` 
    FROM
        SC 
    GROUP BY
    SC.CId 
    ) AS p4 ON Course.CId = p4.CId;
21.查詢各科成績前三名的記錄
SELECT
    sc1.* 
FROM
    SC sc1
    LEFT JOIN SC sc2 ON sc1.CId = sc2.CId 
    AND sc1.score < sc2.score 
GROUP BY
    sc1.SId,
    sc1.CId 
HAVING
    COUNT( sc2.CId ) < 3 
ORDER BY
    sc1.CId;
22.查詢每門課程被選修的學生數(shù)
SELECT
    CId,
    COUNT( SId ) 
FROM
    SC 
GROUP BY
    CId;
23.查詢出只選修兩門課程的學生學號和姓名
SELECT
    Student.SId,
    Student.Sname 
FROM
    SC,
    Student 
WHERE
    SC.SId = Student.SId 
GROUP BY
    SC.SId 
HAVING
    COUNT( * ) = 2;
24.查詢男生、女生人數(shù)
SELECT
    Ssex,
    COUNT( * ) 
FROM
    Student 
GROUP BY
    Ssex;
25.查詢名字中含有「風」字的學生信息
SELECT
    * 
FROM
    Student 
WHERE
    Sname LIKE '%風%';
26.查詢同名學生名單却桶，并統(tǒng)計同名人數(shù)
SELECT
    Sname,
    COUNT( * ) 
FROM
    Student 
GROUP BY
    Sname 
HAVING
    COUNT( * ) > 1;
27.查詢 1990 年出生的學生名單
SELECT
    * 
FROM
    Student 
WHERE
    YEAR ( Sage ) = 1990;
28.查詢每門課程的平均成績境输，結(jié)果按平均成績降序排列，平均成績相同時颖系，按課程編號升序排列
SELECT
    SC.CId,
    Course.Cname,
    AVG( SC.score ) AS average 
FROM
    SC,
    Course 
WHERE
    SC.CId = Course.CId 
GROUP BY
    SC.CId 
ORDER BY
    average DESC,
    CId;
29.查詢平均成績大于等于 85 的所有學生的學號嗅剖、姓名和平均成績
SELECT
    Student.SId,
    Student.Sname,
    AVG( SC.score ) AS average 
FROM
    Student,
    SC 
WHERE
    Student.SId = SC.SId 
GROUP BY
    SC.SId 
HAVING
    average >= 85;
30.查詢課程名稱為「數(shù)學」，且分數(shù)低于 60 的學生姓名和分數(shù)
SELECT
    Student.Sname,
    SC.score 
FROM
    Course,
    SC,
    Student 
WHERE
    Course.Cname = "數(shù)學" 
    AND Course.CId = SC.CId 
    AND SC.score < 60 
    AND Student.SId = SC.SId;
31.查詢所有學生的課程及分數(shù)情況（存在學生沒成績嘁扼，沒選課的情況）
SELECT
    Sname,
    CId,
    score 
FROM
    Student
    LEFT JOIN SC USING ( SId );
32.查詢?nèi)魏我婚T課程成績在 70 分以上的姓名信粮、課程名稱和分數(shù)
SELECT
    Student.Sname,
    Course.Cname,
    SC.score 
FROM
    SC,
    Student,
    Course 
WHERE
    SC.score > 70 
    AND Student.SId = SC.SId 
    AND SC.CId = Course.CId;
33.查詢存在不及格的課程
SELECT DISTINCT
    SC.CId 
FROM
    SC 
WHERE
    SC.score < 60;
34.查詢課程編號為 01 且課程成績在 80 分及以上的學生的學號和姓名
SELECT
    Student.SId,
    Student.Sname 
FROM
    Student,
    SC 
WHERE
    Student.SId = SC.SId 
    AND CId = "01" 
    AND score >= 80;
35.求每門課程的學生人數(shù)
SELECT
    SC.CId,
    COUNT( * ) AS sn 
FROM
    SC 
GROUP BY
    CId;
36.成績不重復(fù)，查詢選修「張三」老師所授課程的學生中趁啸，成績最高的學生信息及其成績
SELECT
    Student.*,
    SC.CId,
    SC.score 
FROM
    Teacher,
    Course,
    SC,
    Student 
WHERE
    Teacher.Tname = "張三" 
    AND Teacher.TId = Course.TId 
    AND Course.CId = SC.CId 
    AND SC.SId = Student.SId 
ORDER BY
    SC.score DESC 
    LIMIT 1;
37.成績有重復(fù)的情況下强缘，查詢選修「張三」老師所授課程的學生中，成績最高的學生信息及其成績
SELECT Student.*,SC.CId,SC.score 
    FROM Teacher,Course,SC,Student
    WHERE Teacher.Tname="張三"
    AND Teacher.TId=Course.TId
    AND Course.CId=SC.CId 
    AND SC.SId=Student.SId 
    AND SC.score=
    (SELECT MAX(SC.score)
    FROM Teacher,Course,SC,Student
    WHERE Teacher.Tname="張三"
    AND Teacher.TId=Course.TId
    AND Course.CId=SC.CId 
    AND SC.SId=Student.SId );
38.查詢不同課程成績相同的學生的學生編號不傅、課程編號旅掂、學生成績
SELECT
    sc1.* 
FROM
    SC sc1
    JOIN SC sc2 USING ( SId ) 
WHERE
    sc1.CId != sc2.CId 
    AND sc1.score = sc2.score 
GROUP BY
    sc1.CId;
39.查詢每門課程成績最好的前兩名
SELECT
    sc1.* 
FROM
    SC sc1
    LEFT JOIN SC sc2 ON sc1.CId = sc2.CId 
    AND sc1.score < sc2.score 
GROUP BY
    sc1.SId,
    sc1.CId 
HAVING
    COUNT( sc2.CId ) < 2 
ORDER BY
    sc1.CId;
40.統(tǒng)計每門課程的學生選修人數(shù)（超過 5 人的課程才統(tǒng)計）
SELECT
    SC.CId,
    COUNT( SId ) AS cc 
FROM
    SC 
GROUP BY
    CId 
HAVING
    cc > 5;
41.檢索至少選修兩門課程的學生學號
SELECT
    SC.SId,
    COUNT( SId ) AS cc 
FROM
    SC 
GROUP BY
    SId 
HAVING
    cc >= 2;
42.查詢選修了全部課程的學生信息
SELECT
    Student.* 
FROM
    SC,
    Student 
WHERE
    SC.SId = Student.SId 
GROUP BY
    SC.SId 
HAVING
    COUNT( * ) = ( SELECT COUNT( * ) FROM Course );
43.查詢各學生的年齡，只按年份來算
SELECT
    SId,
    Sname,
    YEAR ( CURDATE( ) ) - YEAR ( Sage ) AS age 
FROM
    Student;
44.按照出生日期來算访娶，當前月日 < 出生年月的月日則商虐，年齡減一
SELECT
    SId,
    Sname,
    TIMESTAMPDIFF( YEAR, Sage, CURDATE( ) ) AS age 
FROM
    Student;
45.查詢本周過生日的學生
SELECT
    * 
FROM
    Student 
WHERE
    WEEKOFYEAR( Sage ) = WEEKOFYEAR( CURDATE( ) );
查詢下周過生日的學生
SELECT
    * 
FROM
    Student 
WHERE
    WEEKOFYEAR( Sage ) = WEEKOFYEAR( CURDATE( ) ) + 1;
46.查詢本月過生日的學生
SELECT
    * 
FROM
    Student 
WHERE
    MONTH ( Sage ) = MONTH ( CURDATE( ) );
47.查詢下月過生日的學生
SELECT
    * 
FROM
    Student 
WHERE
    MONTH ( Sage ) = MONTH ( CURDATE( ) ) + 1;
?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者
  • 人面猴
    序言：七十年代末，一起剝皮案震驚了整個濱河市，隨后出現(xiàn)的幾起案子称龙，更是在濱河造成了極大的恐慌留拾，老刑警劉巖，帶你破解...
    沈念sama閱讀 219,490評論 6贊 508
  • 死咒
    序言：濱河連續(xù)發(fā)生了三起死亡事件鲫尊，死亡現(xiàn)場離奇詭異痴柔，居然都是意外死亡，警方通過查閱死者的電腦和手機疫向，發(fā)現(xiàn)死者居然都...
    沈念sama閱讀 93,581評論 3贊 395
  • 救了他兩次的神仙讓他今天三更去死
    文/潘曉璐 我一進店門咳蔚，熙熙樓的掌柜王于貴愁眉苦臉地迎上來，“玉大人搔驼，你說我怎么就攤上這事谈火。” “怎么了舌涨？”我有些...
    開封第一講書人閱讀 165,830評論 0贊 356
  • 道士緝兇錄：失蹤的賣姜人
    文/不壞的土叔 我叫張陵糯耍，是天一觀的道長。 經(jīng)常有香客問我囊嘉，道長温技，這世上最難降的妖魔是什么？ 我笑而不...
    開封第一講書人閱讀 58,957評論 1贊 295
  • ?港島之戀（遺憾婚禮）
    正文 為了忘掉前任扭粱，我火速辦了婚禮舵鳞，結(jié)果婚禮上，老公的妹妹穿的比我還像新娘琢蛤。我一直安慰自己蜓堕，他們只是感情好，可當我...
    茶點故事閱讀 67,974評論 6贊 393
  • 惡毒庶女頂嫁案：這布局不是一般人想出來的
    文/花漫 我一把揭開白布博其。 她就那樣靜靜地躺著套才，像睡著了一般。 火紅的嫁衣襯著肌膚如雪贺奠。 梳的紋絲不亂的頭發(fā)上霜旧，一...
    開封第一講書人閱讀 51,754評論 1贊 307
  • 城市分裂傳說
    那天，我揣著相機與錄音儡率，去河邊找鬼。 笑死以清，一個胖子當著我的面吹牛儿普，可吹牛的內(nèi)容都是我干的。 我是一名探鬼主播掷倔，決...
    沈念sama閱讀 40,464評論 3贊 420
  • 雙鴛鴦連環(huán)套：你想象不到人心有多黑
    文/蒼蘭香墨 我猛地睜開眼眉孩，長吁一口氣：“原來是場噩夢啊……” “哼！你這毒婦竟也來了？” 一聲冷哼從身側(cè)響起浪汪，我...
    開封第一講書人閱讀 39,357評論 0贊 276
  • 萬榮殺人案實錄
    序言：老撾萬榮一對情侶失蹤巴柿，失蹤者是張志新（化名）和其女友劉穎，沒想到半個月后死遭，有當?shù)厝嗽跇淞掷锇l(fā)現(xiàn)了一具尸體广恢，經(jīng)...
    沈念sama閱讀 45,847評論 1贊 317
  • ?護林員之死
    正文 獨居荒郊野嶺守林人離奇死亡，尸身上長有42處帶血的膿包…… 初始之章·張勛 以下內(nèi)容為張勛視角 年9月15日...
    茶點故事閱讀 37,995評論 3贊 338
  • ?白月光啟示錄
    正文 我和宋清朗相戀三年呀潭，在試婚紗的時候發(fā)現(xiàn)自己被綠了钉迷。 大學時的朋友給我發(fā)了我未婚夫和他白月光在一起吃飯的照片。...
    茶點故事閱讀 40,137評論 1贊 351
  • 活死人
    序言：一個原本活蹦亂跳的男人離奇死亡钠署，死狀恐怖糠聪，靈堂內(nèi)的尸體忽然破棺而出，到底是詐尸還是另有隱情谐鼎，我是刑警寧澤舰蟆，帶...
    沈念sama閱讀 35,819評論 5贊 346
  • ?日本核電站爆炸內(nèi)幕
    正文 年R本政府宣布，位于F島的核電站狸棍，受9級特大地震影響夭苗，放射性物質(zhì)發(fā)生泄漏。R本人自食惡果不足惜隔缀，卻給世界環(huán)境...
    茶點故事閱讀 41,482評論 3贊 331
  • 男人毒藥：我在死后第九天來索命
    文/蒙蒙 一题造、第九天 我趴在偏房一處隱蔽的房頂上張望。 院中可真熱鬧猾瘸，春花似錦界赔、人聲如沸。這莊子的主人今日做“春日...
    開封第一講書人閱讀 32,023評論 0贊 22
  • 一樁弒父案淮悼，背后竟有這般陰謀
    文/蒼蘭香墨 我抬頭看了看天上的太陽。三九已至揽思，卻和暖如春袜腥，著一層夾襖步出監(jiān)牢的瞬間，已是汗流浹背钉汗。 一陣腳步聲響...
    開封第一講書人閱讀 33,149評論 1贊 272
  • 情欲美人皮
    我被黑心中介騙來泰國打工羹令， 沒想到剛下飛機就差點兒被人妖公主榨干…… 1. 我叫王不留，地道東北人损痰。 一個月前我還...
    沈念sama閱讀 48,409評論 3贊 373
  • 代替公主和親
    正文 我出身青樓福侈，卻偏偏與公主長得像，于是被迫代替她去往敵國和親卢未。 傳聞我的和親對象是個殘疾皇子肪凛，可洞房花燭夜當晚...
    茶點故事閱讀 45,086評論 2贊 355

推薦閱讀更多精彩內(nèi)容

  • 網(wǎng)上流傳較廣的50道SQL訓練堰汉，奮斗了不知道多久終于寫完了。前18道題的難度依次遞增伟墙，從19題開始的后半部分算是循...
    Kaidi_G閱讀 474,925評論 312贊 452
  • 50道SQL練習題及答案與詳細分析 http://www.reibang.com/p/cc23c19ef639[...
    將代碼寫成詩閱讀 2,254評論 0贊 3
  • 一翘鸭，表關(guān)系的練習測試 請創(chuàng)建如下表關(guān)系，并建立相關(guān)約束 一戳葵，創(chuàng)建表結(jié)構(gòu)數(shù)據(jù)： 創(chuàng)建的話肯定先創(chuàng)建沒有關(guān)聯(lián)的表就乓，老師...
    Kevin_Luo閱讀 2,802評論 0贊 0
  • 練習前的準備 SQL環(huán)境搭建 http://www.reibang.com/p/edca5142391c 建表語...
    TOMOCAT閱讀 23,530評論 3贊 30
  • 我使用的Mysql版本是5.7.19。答案可能會因版本會有少許出入譬淳。如果答案有問題歡迎在評論區(qū)指出并給出你的答案档址。...
    大石兄閱讀 16,550評論 8贊 21