Suppose i've a table emp and id is one of the column in it, what will be result for this query.select * from emp where id=99999 and 1=0;
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
- Evaluate the following SELECT statement: SELECT emp_id, name FROM emp WHERE emp_id NOT IN (SELECT emp_id FR...
- If emp table having 10 records what is the output of : select * from emp where rownum=8;
- SELECT STUDENT_ID, MARKS FROM STUDENTS WHERE STUDENT_ID = 119 What will be the output of the above query? A...
- What is the output of the below query? select rowid from dual
- SELECT STUDENT_ID, MARKS FROM STUDENTS WHERE MARKS > 80 What will be the output of the above query?
- The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You...
- The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You...