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

Sql order by

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
Attached Images
File Type: jpg Attachment.jpg (88.7 KB, 138 views)
Sep 7 '16 #1
Share this Question
Share on Google+
2 Replies

P: 36
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.