Search for items with prices greater than or equal to "super" prices, and sorted by price in descending order

--search for items with prices greater than or equal to "super" prices, and sorted by price in descending order//Any usage//used in conjunction with the comparison operator to indicate that any value returned by the subquery is true, or true

//Simple CaseSELECTS1 fromTable1WHERES1>  any(SELECTS2 fromtable2)1In a subquery, all S2 column results for table2 are returned (5, A, -)2The value of S1 in Table1 is then compared with it,3as long as any value greater than S2 is represented as TRUE, the query criteria are metSELECT *  fromTdb_goodsWHEREGoods_price>  any(SELECTGoods_price fromTdb_goodsWHEREGoods_cate= 'Super Ben')ORDER  byGoods_priceDESC;
//In usageSELECT *  fromTdb_goodsWHEREGoods_priceinch(SELECTGoods_price fromTdb_goodsWHEREGoods_cate= 'Super Ben')ORDER  byGoods_priceDESC; In equivalent to =    anySELECT *  fromTdb_goodsWHEREGoods_price=  any(SELECTGoods_price fromTdb_goodsWHEREGoods_cate= 'Super Ben')ORDER  byGoods_priceDESC;

Search for items with prices greater than or equal to "super" prices, and sorted by price in descending order