How many rows records the following query will display.. select * from TEMP where rownum between 0 and 3 ? N.R. Temp table has 30 records
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- What is the output of the given query? SELECT ROWNUM,ENAME,SAL FROM EMP WHERE ROWNUM<=2
- Emp table has 10 rows. How many rows will be fetched against the following query? Select 10 from emp where ...
- The table employee contains 20 records. What is the output of the query " Select 8 from Employee"?
- How many rows will the following SQL return : "Select * from emp Where rownum = 10" ?
- If emp table having 10 records what is the output of : select * from emp where rownum=8;
- Which of the following queries returns the number of rows in the table student?
- With SQL, how can you return the number of records in the "Persons" table?
- SELECT STUDENT_ID, MARKS FROM STUDENTS WHERE MARKS > 80 What will be the output of the above query?