SELECT ROWNUM, LEVEL FROM DUAL CONNECT BY LEVEL

How many rows will return from dual table?

Question Posted / sen

Answer Posted / sen

SELECT ROWNUM, LEVEL
FROM DUAL
CONNECT BY LEVEL < 5;

Is This Answer Correct ?

9 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How delete all records from table in sql?

642

What is crud diagram?

597

What is nvl?

697

Can you load data into multiple tables at once? : aql loader

700

What is query optimization in sql?

638

what is the difference difference between procedure and packages

9446

how many ways we can we find the current date using mysql? : Sql dba

715

What is a subquery in sql?

597

what is a foreign key ? : Sql dba

695

What is difference between pl and sql?

616

Is it possible to create the following trigger: before or after update trigger for each row?

822

how to check server status with 'mysqladmin'? : Sql dba

674

Explian rowid, rownum? What are the psoducolumns we have?

667

How does postgresql compare to mysql?

669

What are the types of sql commands?

658