By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,882 Members | 2,453 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,882 IT Pros & Developers. It's quick & easy.

Sql order by

ayakamacy
P: 14
Hello there, can anyone help me out with this problem? How to Query this:



My query code:

Expand|Select|Wrap|Line Numbers
  1. SELECT TOP 1000 [WireID]
  2.   ,[PadNo]
  3.   ,[Pattern]
  4.   ,[Tester]
  5. FROM [WLSystem].[dbo].[TblR8Pure] ORDER BY LEN(Tester), Tester ASC
  6. GO
  7.  
Attached Images
File Type: jpg Attachment.jpg (88.7 KB, 133 views)
Sep 7 '16 #1
Share this Question
Share on Google+
2 Replies


P: 17
Try this query for order by
Expand|Select|Wrap|Line Numbers
  1. SELECT * FROM ("Your table name")
  2. ORDER BY ("Column name");
May 8 '19 #2

P: 1
Expand|Select|Wrap|Line Numbers
  1. SELECT *, SUBSTRING(Jumper,1,CHARINDEX(',',Jumper)-1) as OrderJumper FROM table ORDER BY OrderJumper ASC
May 10 '19 #3

Post your reply

Sign in to post your reply or Sign up for a free account.