You attempt to query the data base with this command:
SELECT name, salary FROM employee WHERE salary=(SELECT
salary FROM employee WHERE last name='Wagner' OR dept no=233)
Choose most appropriate option from the following:
1)Sub-queries are not allowed in the where clause.
2)a multiple row sub-query used with a single row comparison
operator.
3)a single row query is used with a multiple row comparison
operator.
Answer Posted / dilip
the answer is b becouse the query the query compares one
row at a time and there is multiple rows generated in
subqueries
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the use of oops?
what are the realtime excercises in C++?
i=20;k=0;
for(j=1;k-i;k+=j<10?4:3)
{
cout< What is Difference Between Inheritance and creating object
and getting data? means
Class A extends B{
B.getMethod();}
(OR)
Class A{
b obj=new B();
obj.getMethod();
} Can private class be inherited? What do you mean by abstraction? What is polymorphism oop? write a program that takes input in digits and display the
result in words from 1 to 1000 What is abstraction in oops with example? write a code for this. serial_number contained in the
header of the file will be read , if this serial number is
less than a previous serial number within a successfully
processed file, or is the same as another serial number
within a successfully processed file, or if the field
contains anything other than 7 digits, then the file must
error with the reason ‘Invalid SERIAL_NUMBER’. Please send ford technologies placement paper 2 my mail id officer say me - i
am offered to a
smoking , then what
can you say hi, this is raju,iam studying b.tech 2nd year,iam want know
about group1 and group2 details, and we can studying
without going to any instutions? please help me. What is polymorphism what are the different types of polymorphism? What is Difeerence between List obj=new ArrayList(); and
ArrayList obj=new ArrayList()?