Home » SQL & PL/SQL » SQL & PL/SQL » query2 (oracle9i)
query2 [message #389748] Tue, 03 March 2009 07:55 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
select * from emp,dept
where emp.deptno!=dept.deptno;

How many rows will return?
Re: query2 [message #389750 is a reply to message #389748] Tue, 03 March 2009 07:58 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
42

Please at least _try_ to do your homework yourself.

[Updated on: Tue, 03 March 2009 07:59]

Report message to a moderator

Re: query2 [message #389752 is a reply to message #389748] Tue, 03 March 2009 08:01 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
ramesh55.sse wrote on Tue, 03 March 2009 08:55
select * from emp,dept
where emp.deptno!=dept.deptno;

How many rows will return?


Trick question. The table doesn't exist. So I guess you can say zero or NULL.
Re: query2 [message #389753 is a reply to message #389752] Tue, 03 March 2009 08:08 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
LOL Laughing
Re: query2 [message #389758 is a reply to message #389748] Tue, 03 March 2009 08:12 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Follow the guide and try to do your homework yourself.

Regards
Michel
Previous Topic: query
Next Topic: Password encryption
Goto Forum:
  


Current Time: Sat Dec 10 16:49:28 CST 2016

Total time taken to generate the page: 0.07088 seconds