Emp table has 10 rows. How many rows will be fetched against the following query? Select 10 from emp where rownum>=2

Keep practicing — related questions

• If emp table having 10 records what is the output of : select * from emp where rownum=8;
• How many rows will the following SQL return : "Select * from emp Where rownum = 10" ?
• If emp table is having 10 rows, which of the below queries executes successfully without error? A) delete f...
• What will be the output of following Select 8 from Emp ? Emp table has 10 rows
• Output of the query if emp table is having 100 rows: select rownum from emp group by rownum having rownum =...
• What is the output of the given query? SELECT ROWNUM,ENAME,SAL FROM EMP WHERE ROWNUM<=2
• How many rows records the following query will display.. select * from TEMP where rownum between 0 and 3 ? ...
• How many rows records the following query will display.. select * from TEMP where rownum in (1,3,3,2) N.R. ...