official microblog released news that the SFC approved the initial application of 30 companies in accordance with legal procedures. Among them, SSE 11, szse SME Board 2, Gem 17, the relevant enterprises and their underwriters will be in consultation with the Shanghai and Shenzhen exchanges to determine the issue schedule, and published prospectus.In particular, the 11 companies intending to land in SSE are: Liaoning Fu Saddle Heavy Industry Co., Ltd.
). Finally, remove the first 10 from each class. That is the realization of our purpose. After testing, this kind of writing efficiency is high, recommend everybody use
Now let's look at an example
The code is as follows
Copy Code
CREATE TABLE table1 ([ID] [bigint] IDENTITY (1,1) not NULL, [Name] [nvarchar] (128) Not NULL, [class] int is not NULL, [Date] datetime NOT NULL)
class represents the category number. The number of categories is not fixed, there a
Create table table1 ([ID] [bigint] IDENTITY (1,1) not null, [Name] [nvarchar] (128) not null, [class] int not null, [date] datetime not null) class indicates the category number. The number of categories is not fixed. There are at least thousands of categories.Date indicates the time when the record is updated.We want to obtain the latest 5 records for each category.SolutionSelect id, name, class, date from (select id, name, class, date, row_number () over (partition by class order by date desc)
Obtain the latest SQL implementation code for each category. For more information, see
Obtain the latest SQL implementation code for each category. For more information, see
Create table table1 ([ID] [bigint] IDENTITY (1,1) not null, [Name] [nvarchar] (128) not null, [class] int not null, [date] datetime not null) class indicates the category number. The number of categories is not fixed. There are at least thousands of categories.
Date indicates the time when the record is updated.
We want to
Create table table1 ([ID] [bigint] IDENTITY (1,1) not null, [Name] [nvarchar] (128) not null, [class] int not null, [date] datetime not null) class indicates the category number. The number of categories is not fixed. There are at least thousands of categories.
Date indicates the time when the record is updated.
We want to obtain the latest 5 records for each category.
Solution
Select id, name, class, date from (select id, name, class, date, row_number () over (partition by class order by date d
CREATE TABLE table1 ([ID] [bigint] IDENTITY (1,1) not NULL, [Name] [nvarchar] (128) Not NULL, [class] int is not NULL, [date] D Atetime NOT NULL) class represents the category number. The number of categories is not fixed, there are at least thousands of categories
Date indicates when the record was updated
We now want to get the latest updated 5 records for each category.
Solution
Select Id,name,class,date from (select Id,name,class,date, Row_number () over (partition by class ORDER by date des
Xi'an future international software Co., Ltd. (Finance and e-government)Xi'an collaborative digital Co., Ltd. (middleware)Shaanxi Yixin Network Technology Co., Ltd. (Water Conservancy industry)Xi'an Jiaotong University botong Information Co., Ltd. (Enterprise Informatization)Xi'an New Generation Technology Development
of Telecommunications Science and Technology (Datang Telecom Technology Industry Group), Holley Group Co., Ltd., Huawei Technology Co., Ltd., Lenovo (Beijing) Co., Ltd., Shenzhen ZTE Co., Ltd., China Electronic Information Industry Group, China Putian Information Industry Group, Beijing Tian Acer Technology Co.,
China Private Logistics Enterprise Top 30 www.jctrans.com 2004-11-23 16:54:14 place name registered address
1 Jin Cheng International Logistics Group Co., Ltd. Dalian
2 Heilongjiang Huayu Logistics Group Co., Ltd. Jiamusi
3 Tianjin Datian Group Co., Ltd. Beijing
4 Shanghai Jia Ji Express Co., Ltd. Shanghai
5 Shenzhen
China's local management consulting company ranked TOP501. BEIJING Zheng June Strategy Management Consultants Limited2. BEIJING and June Consulting company3. North Latitude Management consulting company4. Far Zhuo Management consulting company5. AMT Management consulting Company6. Huaxia Cornerstone Management Consulting Co., Ltd.7. BEIJING Nine Management Consulting Co., Ltd.8. Yu Woo Management Consulting
C # overview of the object-oriented design model (1): Face-to-Face Design Model and mongo.zip
Lecture content: this training course introduces the basic concepts and principles of object-oriented design patterns and demonstrates the practical application of Object-Oriented Design Patterns in. NET Framework programming. Course Lecturer: Li Jianzhong Senior Training lecturer of Shanghai Zhucheng Information Technology Co., Ltd..
vital investment reference for business and investment professionals, it also helps readers understand the Chinese stock market and win in practice.
Directory
Lunch with Buffett: An Interview with Chinese capital tycoon
Preface an investment course to change life
Previous Stock market topic
1 Hong Kong stock God Cao renchao:
We strongly disagree with "value investment methods"
2. Cao Mingcheng, Senior private equity holder and president of Hainan Tiancheng investment company:
In early years, tr
few examples here, we take a look at the Kunshan Economic Development Zone (one of China's 20 state-level investment development zones) inside a few of the largest companies, to see the following so-called star Enterprises, are invested in more than tens of millions of dollars or even billions of large companies:
ren Bao computer Industry (China) Co., Ltd. Sihai Electronics (Kunshan) Co., Ltd. Kunshan Uni
The five "Special Contribution Award" are:1. Weixin2. Symbian,3. Qualcomm,4. dotmobi,5. taijing Information Technology (Shanghai) Co., Ltd.
Which of the following is the winner of the 25 "Single Gold Medal: 1. The best Mobile 2.0 application platform golden branch award letter,2. Hanwang Technology Co., Ltd,3. The best Mobile Phone image and Text Recognition Technology Jin Zhi prize Hanwang Technology Co.
was officially opened. The following companies are involved in the bidding: Kunming Xin Xiang Technology Co., Ltd., Simon Yunnan Branch, Kunming Xin Yi Technology Co., Ltd., Guangzhou one-dimensional Industry Co., Ltd., and Zhejiang electronic wave Technology Co., Ltd, shenzhen Funan Information Co.,
their historical backgrounds:
1.1 automation background vendor
These vendors were originally engaged in automation-related businesses. Later, they were optimistic about the market opportunities of industrial control security and set up industrial control security departments or subsidiaries to enter the industrial control security field.
Typical Manufacturers include: Qingdao haitianyao Automatic Control System Co., Ltd., Beijing Li control huakang T
kaishi nitrogen determination method to obtain a false high protein content.
Melamine contains up to 66.6% nitrogen and is white and tasteless. It is an ideal protein impersonate without a simple method. It is estimated that the testing protein content will be increased by one percentage point in plant protein powder and feed, with melamine spending only 1/5 of the actual protein raw material.
Recent detection report:
Ranking melamine infant formula milk powder enterprise list nominal enterpris
advanced technical support, on the other hand, the DA Tai PLC wireless communication expert team has accumulated 12 years of Product Operation Experience and can provide a large number of application implementation solutions.
2. Application in industrial automation:
In the field of industrial automation, the accuracy of sensor detection data is quite required. Long wire circuits encounter obstacles such as roads, railways or rivers, and complex terrain usually make installation costs ver
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.