Advertisement

05.29.2008 at 07:56AM PDT, ID: 23441623
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
8.8

SQL Order By not sorting data properly

Asked by tarashea in SQL Server 2005, Databases Miscellaneous, MS SQL Server

Tags: ,

I enter this SQL statement:

SELECT     Grain_Corn_Parent_Hybrid, Grain_Corn_Hybrids_with_Same_Base_Genetics, Grain_Corn_Relative_Maturity
FROM         Grain_Corn
ORDER BY Grain_Corn_Relative_Maturity, Grain_Corn_Parent_Hybrid

But the returned data is coming back NOT in order by relative maturity first.  Am I doing something wrong?  I have attached a snippet of how the data is getting returned.

I don't understand why the relative maturity starts blank, then goes to 101, but then at hybrid 2J086 it goes back down to 80 and starts over.Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:

2R735	
	2J463	
	2M495	
	2D519	
	2E526	
	2D555	
	2W586	
	2G611	
	2E633	
	2P686	
	2H697	
	2T699	
	2W705	
	2E705	
	2E762	
	2D679	
	2T092	
	2J337	
	2G847	
	2H789	
2A498	2A517	101
2E522	2E522	101
2H521	2H521	102
2J525	2J525	102
2K541	2K540	102
2P531	2P531	102
2D551	2D551	103
2D551	2D557	103
2J525	2J527	103
2J525	2J529	103
2K541	2K541	103
2K541	2K546	103
2P531	2P535	103
2G621	2G621	104
2H546	2H546	104
2R570	2R570	104
2R570	2R572	104
2R570	2R577	104
2G621	2G627	105
2G621	2G628	105
2H546	2H544	105
2M568	2M568	105
2W587	2W587	105
2C591	2C591	106
2C591	2C593	106
2C591	2C597	107
2C591	2C598	107
2C591	2C596	107
2D673	2D653	107
2E636	2E636	107
2D673	2D663	108
2K662	2K662	108
2D673	2D673	109
2D673	2D675	109
2J665	2J665	109
2R691	2R691	109
2R691	2R693	109
2E683	2E683	110
2J665	2J668	110
2J665	2J669	110
2M695	2M695	110
2C727	2C725	111
2E683	2E764	111
2K717	2K718	111
2K717	2K717	111
2K717	2K719	111
2P722	2P722	111
2W705	2W704	111
2A720	2A720	112
2C727	2C729	112
2C727	2C730	112
2C727	2C727	112
2R731	2R731	112
2A765	2A765	113
2G779	2G779	113
2M746	2M746	113
2M746	2M744	113
2T780	2T777	113
2V732	2V732	113
2Y737	2Y737	113
2Y737	2Y739	113
2H790	2H790	114
2M746	2M748	114
2M746	2M747	114
2M746	2M749	114
2M746	2M750	114
2T780	2T780	114
2T780	2T783	114
2T780	2T785	114
2T780	2T787	114
2T780	2T789	114
2T804	2T804	114
2T804	2T807	114
2M797	2M797	115
2T826	2T828	115
2T826	2T826	115
2T826	2T832	115
2W814	2W814	115
2G830	2G830	116
2J086	2J086	80
2K150	2K150	82
2K150	2K152	82
2K150	2K154	83
2P172	2P172	84
2P172	2P174	85
2P172	2P176	85
2T220	2T220	86
2J271	2J271	87
2J271	2J272	87
2D322	2D322	91
2D322	2D324	92
2D322	2D326	92
2T336	2T336	92
2G434	2G434	95
2R416	2R416	95
2R416	2R430	95
2G434	2G436	96
2R416	2R424	96
2R416	2R426	96
2R416	2R428	96
2P480	2P480	97
2P480	2P483	97
2P480	2P484	97
2A498	2A496	99
2A498	2A498	99
2D468	2D468	99
[+][-]05.29.2008 at 07:57AM PDT, ID: 21669721

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.29.2008 at 07:59AM PDT, ID: 21669739

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, Databases Miscellaneous, MS SQL Server
Tags: SQL, SQL Server 2005
Sign Up Now!
Solution Provided By: Thomasian
Participating Experts: 2
Solution Grade: A
 
 
[+][-]05.29.2008 at 08:03AM PDT, ID: 21669772

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628