Home >Database >Mysql Tutorial >Detailed introduction to sorting a certain column

Detailed introduction to sorting a certain column

零下一度
零下一度Original
2017-06-10 15:08:531440browse

This article mainly introduces the sorting of a certain row or column in mysql. Friends who need it can refer to the following method: It cannot be achieved through desc:: Method 1: select sp.productid,sp.productname,ss.sku from sp_product sp inner join sku_skus ss on sp.productid=ss.productid where sp.productname='Lux lasting skin rejuvenating soap 115g' or sp.productname='Crest Green Tea Mint Toothpaste 180g' or sp.productname='Xinwei Orchard Orchid Bean 190g/bag 1 bag

1. How to specify a row or column in mysql to sort the implementation method analysis (picture)

Detailed introduction to sorting a certain column

Introduction: This article mainly introduces mysql to specify the sorting of a certain row or column. Friends who need it can Refer to the following

2. ExtJS4.2 learning (4) Grid table Chinese sorting problem

Introduction: We are here When specifying a certain column in the table to sort, I found that the Chinese characters were not sorted according to the rules. Internationally, ASCII codes are used for sorting, but we sorted them in Pinyin. The Chinese characters automatically sorted by Ext appear to us. It's a mess. The following code data: 1 2 3 4 5 6 7 var data =[ [ '1' , 'Ah' , 'Description01' ], [ '2'

##3. PHP Sort a two-dimensional array by a certain column

#Introduction: /* * Sort a two-dimensional array by a certain column* array_multisort($arr1,$arr2) * The manual example is as follows * */ $data[] = array(volume = 67, edition = 2);$data[] = array(volume = 86, edition = 1);$data[] = array(volume = 85, edition = 6) ;$data[] = array(volume = 98, edition

The above is the detailed content of Detailed introduction to sorting a certain column. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn