What will be the output for the below Query
Select 'High' from dual where null = null;
Answers were Sorted based on User's Feedback
Answer / shijo
The Answer will always be null, since you never can equate a
NULL to another NULL. if the query was "Select 'High' from
dual where null IS null;" The answer would have been "High"
Is This Answer Correct ? | 61 Yes | 19 No |
Answer / abhishek6555
The answer will be no rows selected as null = null will be
false condition and the where condition will become false.
Is This Answer Correct ? | 14 Yes | 7 No |
Answer / amedela chandra sekhar
The correct answer is
SQL> Select 'High' from dual where null = null;
no rows selected
Chandu
chandumba2005@gmai.com
Is This Answer Correct ? | 9 Yes | 5 No |
Answer / kart
since the query is syntaxically correct
the output will be
no rows selected;
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / vijay repe
Query will give o/p as 'High' if condition u put as null is
null insteat of null = null.
It considers as false where condition same as 1=2;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sri
two nulls are not equal
so the answer is no rows selected.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / zia
Syntax is correct, but result will show only column heading without data as 'HIGH'.
Is This Answer Correct ? | 2 Yes | 3 No |
What are sql functions? Describe the different types of sql functions?
What is the basic difference between a sql and stored procedure ?
How do I start sql from command line?
Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.
What is data profiling in sql?
What are the types of SQL Statement?
What is the difference between left and left outer join?
What is the difference between a subquery and a join?
i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent
What is the difference between instead of trigger and after trigger?
What is record data type?
Why trigger is used in sql?