title: Where and Order By Clauses in Cassandra CQL
body: <p>I am new to NoSQL database and have just started using apache Cassandra. I created a simple table "emp" with primary key on "empno" column. This is a simple table as we always get in Oracle's default scott schema.</p>
  
  <p>Now I loaded data using the <code>COPY</code> command and issued query <code>Select * from emp order by empno</code> but I was surprised that CQL did not allow Order by on <code>empno</code> column (which is PK). Also when I used <code>Where</code> condition, it did not allow any inequality operations on empno column (it said only EQ or IN conditions are allowed). It also did not allowed Where and Order by on any other column, as they were not used in PK, and did not have an index.</p>
  
  <p>Can someone please help me what should I do if I want to keep <code>empno</code> unique in the table and want a query results in Sorted order of <code>empno</code>?</p>
  
  <p>(My version is: </p>
  
  <p><code>cqlsh:demodb&gt; show version
  [cqlsh 5.0.1 | Cassandra 2.2.0 | CQL spec 3.3.0 | Native protocol v4]</code>
  )</p>