By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,097 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 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, 132 views)
Sep 7 '16 #1
Share this Question
Share on Google+
2 Replies


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

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

Post your reply

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