top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Oracle: How many rows will the following SQL return?

+1 vote
338 views

How many rows will the following SQL return : 

Select * from emp Where rownum < 10;
posted Dec 31, 2014 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

It returns only 9 rows.

answer Jan 2, 2015 by Arun Gowda
Similar Questions
+1 vote
Oracle: How many rows will the following SQL return?

How many rows will the following SQL return :

  Select * from emp Where rownum = 10;
+1 vote
Oracle: which of the following is better to find the number of rows in a table?

which of the following is better to find the number of rows in a table?
1. count(1)
2. count(*)
3. count(rowid)

+1 vote
How do I can quickly open a 8Gb dsv file with 40 million rows with oracle sql developer?

How do I can quickly open a 8Gb dsv file with 40 million rows with oracle sql developer?
I did it with a best laptop with high cpu speed but it took one day, I'm looking for a faster way...

...