What do SELECT 1 and SELECT COUNT(1) do in Oracle SQL?
<p>So I just had an interview today for a java developer position, and they asked me this question</p>

<p>Can you tell the difference for</p>

<pre><code>SELECT 1 FROM table
SELECT count(1) FROM table
SELECT count(*) FROM table
</code></pre>

<p>I looked up on stack overflow but couldn't find a satisfactory answer. I have been a Java developer with knowledge on SQL for a couple years, but have never had to use unfamiliar statements like Select 1 or select count(1)</p>

<p>Also this is the entire question. i.e, these queries are not part of any bigger query.</p>

<p>Could you please help me get an answer for this?</p>