SQL Server2005 [英] sql server2005

问题描述

我们有10个名字中的10个名字5个名字以sri开头，而5个名字以mrs开头，所以我想按升序命名，请向我发送查询.

we have 10 names in 10 name 5 names begins with sri and 5 names begins with mrs so i want namewise in ascending order please send me the query.

推荐答案

select * from [table] order by [name]

这篇关于SQL Server2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！