topic SQL Requirement in QlikView https://community.qlik.com/t5/QlikView/SQL-Requirement/m-p/543063#M202924 <HTML><HEAD></HEAD><BODY><P><BR />Hi All,</P><P></P><P>Could some one help me with a requirement like this ?</P><P></P><P>Suppose my query is like this, which hits the database:</P><P></P><P>SELECT * from Schema.TableName;</P><P></P><P>Result (Alphabetically):</P><P>A</P><P>ALL</P><P>B</P><P>BALL</P><P>C</P><P>CAT</P><P>D</P><P>DOLL</P><P>E</P><P>EGG</P><P></P><P><STRONG>Now my requirement is to get the reult in which 'ALL' should be at first</STRONG>, then rest of the values Alphabetically. Quite interesting gonna be. Please guide. </P></BODY></HTML> Thu, 19 Sep 2013 13:15:10 GMT dmohanty 2013-09-19T13:15:10Z SQL Requirement https://community.qlik.com/t5/QlikView/SQL-Requirement/m-p/543063#M202924 <HTML><HEAD></HEAD><BODY><P><BR />Hi All,</P><P></P><P>Could some one help me with a requirement like this ?</P><P></P><P>Suppose my query is like this, which hits the database:</P><P></P><P>SELECT * from Schema.TableName;</P><P></P><P>Result (Alphabetically):</P><P>A</P><P>ALL</P><P>B</P><P>BALL</P><P>C</P><P>CAT</P><P>D</P><P>DOLL</P><P>E</P><P>EGG</P><P></P><P><STRONG>Now my requirement is to get the reult in which 'ALL' should be at first</STRONG>, then rest of the values Alphabetically. Quite interesting gonna be. Please guide. </P></BODY></HTML> Thu, 19 Sep 2013 13:15:10 GMT https://community.qlik.com/t5/QlikView/SQL-Requirement/m-p/543063#M202924 dmohanty 2013-09-19T13:15:10Z Re: SQL Requirement https://community.qlik.com/t5/QlikView/SQL-Requirement/m-p/543064#M202925 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>Try this!</P><P></P><P><IMG alt="Skärmklipp1.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/46715_Skärmklipp1.PNG.png" /></P><P><IMG alt="Skärmklipp2.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/46716_Skärmklipp2.PNG.png" /></P></BODY></HTML> Thu, 19 Sep 2013 14:37:44 GMT https://community.qlik.com/t5/QlikView/SQL-Requirement/m-p/543064#M202925 antose 2013-09-19T14:37:44Z