what is the output of this query selet * from employee
where 1=2 ??
Answer Posted / rohan mhatre
It will return 0 rows....since condition in where clause
will fail as 1 is not equal to 2
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
What is difference between inner join and self join?
How do you declare a constant?
How to run sql*plus commands in sql developer?
How can you fetch common records from two tables?
Can we use join in subquery?
Does sql*plus have a pl/sql engine?
Can a trigger call a stored procedure?
Define a temp table?
How do you clear the screen in sql?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
how to get a list of columns in an existing table? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Explain the working of foreign key?
What do you mean by “trigger” in sql?