Suppose emp table contains 5 records then Select 1 from emp; o/p ?

Keep practicing — related questions

• What will be the output of following Select 8 from Emp ? Emp table has 10 rows
• Consider an emp table having columns empno, empname, salary Which of the following queries sort emp table b...
• Consider the emp table having columns empno, ename Which of the following SQL query fetches empno that occu...
• If emp table is having 10 rows, which of the below queries executes successfully without error? A) delete f...
• Use these data for the following Questions EMPNO ENAME SAL A822 RAMASWAMY 3500 A812 NARAYAN 5000 A973 UMESH...
• Use these data for the following Questions EMPNO ENAME SAL A822 RAMASWAMY 3500 A812 NARAYAN 5000 A973 UMESH...
• Emp table has 10 rows. How many rows will be fetched against the following query? Select 10 from emp where ...
• If emp table having 10 records what is the output of : select * from emp where rownum=8;