select distinct alternative for very large data
<p>I have a very large data. The query below takes approx 12 seconds to work. Is there a faster alternative? Srno is primary key and multiple occurances of class are there</p>

<pre><code>select DISTINCT class
from            data.class
order by        srno desc
</code></pre>