array of elements, and can also be arranged alphabetically by number size. Listing B shows us an example of it:
Listing B
Copy Code code as follows:
?>
Its output results are as follows:
Copy Code code as follows:
Array ([0] => 8
[1] => 7
[2] => 5
[3] => 2
[4] => 1
)
Sort by keyword
When we use arrays, we often reorder them according to the array of keywords, from high to low. The Ksort () function is the sort of function that is sorted
watched by the heavyweight financial media such as Forbes and fortune. So, in 2000, a number of companies led by Goldman Sachs, to invest 5 million of billions of dollars in venture capital, SoftBank Mister Son to give Ma Yun 35 million dollars of investment (Ma Yun too much only accepted 20 million U.S. dollars).
Alibaba was founded at the beginning, Ma Yun has a mantra: "You immediately, now, immediately to do!" Immediately! Righ
enterprises do not have the vision of capital Management.
Unlike Shanda, the focus media is completely a Chinese "concept stock" in Nasdaq. Before the grand listing, its main business-network game has been for its continued to bring huge profits and cash flow, and the 2002 began to start the focus of the media can be in such a short period of time abroad, because it is in the beginning is aimed at the listing.
The main business of the media is in office buildings and other commercial real estat
, typical topological structure is tree-shaped, each onu/ Ont can share the optical fiber between the olt and the optical splitter, save the fiber laying quantity, the business transparence is good, in principle can be applied to any system and rate signal, the network is easy to expand, the Operation management maintenance is simple. (Computer science)
The development of FTTH in foreign countries
A number of international research advisory bodies have maintained a fairly optimistic view of th
country code, but directly using the country name as primary Key)
Country (country)
Population (population)
China
600
United States
100
Canada
100
United Kingdom
200
France
300
Japan
250
Germany
200
Mexico
50
India
250
According to the population data of this country, the population
information given to any country in the region of ' India ' (India), ' Iran ' (Iran)
SELECT * from BBCWHERE Region in(SELECT region from BBCWHERE name in (' India ', ' Iran '))
Third, the European countries with GDP per capita exceeding ' United Kingdom ' (UK).
SELECT name from BBCWHERE region= ' Europe ' and gdp/pop
ignored.One, the known data in a different way to group, analysis. There is the following data: (in order to see more clearly, I did not use the country code, but directly with the country name as primary Key) country (country) population (population) China 600 USA 100 Canada 100 UK 200 France 300 Japan 250 Germany 200 Mexico 50 India 250 According to the population data of this country, the population of Asia and North America is counted. The follow
another way, analyzed. has the following data: (in order to see more clearly, I did not use the country code, but directly with the country name as primary Key)
Country (country)
Population (population)
China
600
United States
100
Canada
100
United Kingdom
200
France
300
Japan
250
Germany
200
Mexico
50
50
India
250
Now to count the number of people on each continent, you can use the following statement:SELECT SUM (population), case country when ' China ' Then ' Asia ' when ' India ' then ' Asia ' when ' Japan ' Then ' Asia ' When ' us ' then ' North America ' when ' Canada ' Then ' Nort
United States
100
Canada
100
UK
200
France
300
Japan
250
Germany
200
Mexico
50
India
250
expected query results:
Chau
Population
Asia
1100
North america
250
Other
700
', 80)INSERT into Testscore values (' John Doe ', ' English ', 90)Select Tname as ' name ',Max (case ttype "language" then Tscor else 0 end) ' Language ',Max (case ttype when ' math ' then Tscor else 0 end) ' Math ',Max (case ttype when ' English ' then Tscor else 0 end) ' English 'From TestscoreGROUP BY TnameExample TwoThere is the following data: (in order to see more clearly, I did not use the country code, but directly with the country name as primary Key)
Country (country)
: (for better understanding, I did not use country code, but directly use the country name as the Primary Key)
Country population (population)
China 600
US 100
Canada 100
UK 200
France 300
Japan 250
Germany 200
Mexico 50
India 250
The population of Asia and North America is counted based on the population data of this country. The following result is returned.
Continent population
Asia 1100
North America 250
Other 700
What do you do if you want to
never get the result of the second type.
The Code is as follows:
Case when col_1 IN ('A', 'B') then' first class'
WHEN col_1 IN ('A') then' Second Class'
ELSE 'others' END
Let's take a look at what we can do with the Case function.
1. Known Data is grouped and analyzed in another way.
There are the following data: (for better understanding, I did not use country code, but directly use the country name as the Primary Key)
Country population (population)
China 600
US 100
Canada 100
UK 200
France
Time zone conversion
The server is located in the United States, but the customer is located in India. Therefore, the local time/server time must be converted to the Indian time. The Code is as follows:
Convert the local time zone to the Indian time zone:
String indianTime = string. Empty;
DateTime localTime = DateTime. Now;
IndianTime = TimeZoneInfo. ConvertTimeBySystemTimeZoneId (localTime, "India
will be with you. in Buddhism, it is more interesting to say that this religion can be regarded as an "God-less" religion. it tells you that everything in the world is false. It is an illusion. even yourself is an illusion. You should not stick to the concept of "I" to reach the realm of "no. you feel terrible fear. The pain is because you keep thinking about "I". If you don't stick to "I", you will be relieved from the pain. or it can be said that all pain is no longer important. You can exper
;
The reform and opening up have dramatically changed all over China. As China joins the WTOThe huge market potential in China has attracted more and more world-leading software companies to enter us.China's software market has become an international competitive market. Compared with India, ChinaThe international level of software enterprises is far from enough.We are lagging behind in terms of management level. We have to work hard and stick to the
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.