是否可以使用Order by Clause排列字符串的升序/降序 [英] Is it possible to Arrange ascending/ Descnding Order of a String Using Order by Clause

问题描述

我有一张桌子员工包含一列

 姓名 
 
来自美国的venkat 
 
来自日本的
 
来自美国的Ramesh 
 
来自日本的Suresh 
 
来自美国的Rajesh 
 
来自美国的Arun 
 
来自日本的Arjun 

我只是想选择一个查询

从姓名desc的员工订单中选择* 

它根据每行的第一个字符给出输出。

但是可以获得基于输出的输出最后一个字符（或）最后一个字符串，如下所示。

来自美国的Venkat 
 
来自America的Ramesh 
 
来自美国的Arun 
 
来自日本的Suchit 
 
来自日本的Suresh 
 
来自日本的Arun 

Plz有人告诉我解决方案.....

解决方案

< BLOCKQUOTE>尝试：

  SELECT  *  FROM 员工 ORDER   BY  REVERSE（名称） DESC  

I have a table Employee contains one Column

Names

venkat from America

suchit from Japan

Ramesh from America

Suresh from Japan

Rajesh from America

Arun from America

Arjun from Japan

I just Want to select a Query

select * from Employee order by Names desc

It gives the Output based on 1st Character of Each Row.
but is it possible to get the Output Based on last Character (or) Last String as Mentioned Below.

Venkat from America

Ramesh from America

Arun from America

Suchit from Japan

Suresh from Japan

Arun from Japan

Plz anyone tell me the Solution.....

解决方案

Try:

SELECT * FROM Employee ORDER BY REVERSE(Names) DESC

这篇关于是否可以使用Order by Clause排列字符串的升序/降序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！