Ancheng

Home/Ancheng

About Ancheng

This author has not yet filled in any details.
So far Ancheng has created 37 blog entries.

如何学习SQL

By |2018-07-26T21:41:25-04:00July 26th, 2018|Categories: Note笔记|Tags: |

如何学习 SQL 语言? - 知乎 经典SQL练习题 - CSDN博客 sql练习网站 - CSDN博客 MySQL SQL常用语句自我测试练习-苦逼程序员-迈进-51CTO博客 将MySQL安装到D盘 – 程泽群的博客 MySQL Commands sql 练习(五) - 简书 经典SQL练习题 查询Score表中的最高分的学生学号和课程号。(子查询或者排序) SELECT sno,cno FROM score WHERE degree =(SELECT MAX(degree) FROM score) select sno, cno from score order by degree desc limit 1,1; 查询Score表中至少有5名学生选修的并以3开头的课程的平均分数。 SELECT AVG(degree),cno FROM score WHERE cno LIKE '3%' GROUP BY [...]

Comments Off on 如何学习SQL

SQL Coding Challenge – Leetcode

By |2018-07-26T21:39:33-04:00July 26th, 2018|Categories: Note笔记|Tags: , , |

Easy Difficulty Combine Two Tables - LeetCode SELECT FirstName, LastName, City, State FROM Person LEFT JOIN Address ON Person.PersonId = Address.PersonId; Second Highest Salary - LeetCode SELECT distinct(Salary) AS SecondHighestSalary FROM Employee UNION SELECT NULL ORDER BY SecondHighestSalary DESC LIMIT 1, 1; Employee Earning More Than Their Managers Assign two different names for single table and [...]

Comments Off on SQL Coding Challenge – Leetcode

Big Data Modelling & Management

By |2018-07-27T08:46:28-04:00July 26th, 2018|Categories: Note笔记|Tags: , |

Data Model Basic Data Operations: selection, projection, union and join Sturctre Person{ firstName: string, lastName: string, DOB: date } Relational Data Model Represented as Table; relational tuple as row in the table Atomic: represent one unit of information and cannot be degraded further Header tells the constaints: ID: Int Primary Key | Fname: string Not null [...]

Comments Off on Big Data Modelling & Management

记一家神奇的公司

By |2018-07-26T19:47:37-04:00July 26th, 2018|Categories: Business工作|

最近暑假没有回国,忙着做RA+找实习,RA的工资其实已经很慷慨了,加上暑假每周都能工作40h,但是考虑到未来的求职,心里还是很慌,赶着实习招聘的尾声继续坚持投简历。

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.
Go to Top