抛鹛蓿客網(wǎng)：非技術(shù)入門題目，已經(jīng)練習(xí)7題目痛单。
https://blog.csdn.net/weixin_55865422/article/details/127475715
對女性嘿棘，男性的分別統(tǒng)計(jì)
https://deepinout.com/sql/sql-questions/865_sql_count_male_female_and_total.html
SQL刪除重復(fù)數(shù)據(jù)只保留一條
https://blog.csdn.net/wintershang/article/details/89205044?spm=1001.2101.3001.6650.1&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7ERate-1-89205044-blog-80907036.235%5Ev38%5Epc_relevant_anti_t3&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7ERate-1-89205044-blog-80907036.235%5Ev38%5Epc_relevant_anti_t3&utm_relevant_index=2
1、查找表中多余的重復(fù)記錄旭绒，重復(fù)記錄是根據(jù)單個(gè)字段（peopleId）來判斷
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
https://www.sohu.com/a/429231087_165070
SELECT*?fromstudent
wherenamein(?selectname
fromstudent
wherenamelike"張%"groupbynamehavingavg(score) >?75);
https://blog.csdn.net/a639735331/article/details/81457628
查詢高考總分在600以上的學(xué)生準(zhǔn)考證號的SQL語句如下所示:
select num from score group by num having sum(score)>600;
有實(shí)操鸟妙，需要注意join的用法。
https://blog.csdn.net/qq_36324958/article/details/128732645?spm=1001.2101.3001.6650.1&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7EBlogCommendFromBaidu%7ERate-1-128732645-blog-81457628.235%5Ev38%5Epc_relevant_anti_t3&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7EBlogCommendFromBaidu%7ERate-1-128732645-blog-81457628.235%5Ev38%5Epc_relevant_anti_t3&utm_relevant_index=2
SQL語句面試題整理-四年經(jīng)驗(yàn)
