Home » SQL & PL/SQL » SQL & PL/SQL » additional condition
additional condition [message #211008] Mon, 25 December 2006 01:31 Go to next message
sandeepshahare
Messages: 20
Registered: December 2006
Location: pune
Junior Member
How will add additional conditions in SQL?

[Updated on: Mon, 25 December 2006 01:31]

Report message to a moderator

Re: additional condition [message #211018 is a reply to message #211008] Mon, 25 December 2006 03:23 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What are "additional conditions in SQL"?

Are you talking about SQL*Plus and ways to modify a current SQL statement? Is this example what you are looking for? If not, don't be shy - explain what you'd like to do, possibly with your own example (which would not work, of course, but others would get an idea).
SQL> select ename from emp
  2  where deptno = 10;

ENAME
----------
CLARK
KING
MILLER

SQL> i    --> i(nsert) another line into the current statement
  3    and sal > 2000;

ENAME
----------
CLARK
KING

SQL> l    --> l(ist) current statement
  1  select ename from emp
  2  where deptno = 10
  3*   and sal > 2000
SQL>

Read this SQL*Plus Command Summary document for more information.
Re: additional condition [message #421861 is a reply to message #211018] Fri, 11 September 2009 04:17 Go to previous messageGo to next message
sukhvinder_tm
Messages: 1
Registered: August 2009
Location: India
Junior Member
Hi I also came across this question in a interview but I unfortunately don't have any idea. Can somebody provide his/her expert comments.
Re: additional condition [message #421862 is a reply to message #211008] Fri, 11 September 2009 04:18 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
We would but we really have no idea what the question means
Re: additional condition [message #421865 is a reply to message #421862] Fri, 11 September 2009 04:23 Go to previous messageGo to next message
ThomasG
Messages: 3185
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
For these kind of interview questions there are usually two posibilities:

1) The person giving the interview is clueless himself.

2) The person giving the interview is asking an un-answerable question on purpose, to see which questions for clarification you ask in return.
Re: additional condition [message #421867 is a reply to message #421865] Fri, 11 September 2009 04:47 Go to previous messageGo to next message
pablolee
Messages: 2813
Registered: May 2007
Location: Scotland
Senior Member
ThomasG wrote on Fri, 11 September 2009 10:23
For these kind of interview questions there are usually two posibilities:

1) The person giving the interview is clueless himself.

2) The person giving the interview is asking an un-answerable question on purpose, to see which questions for clarification you ask in return.

3. The Interview question has been mis-interpreted by the interviewee
Re: additional condition [message #421889 is a reply to message #421861] Fri, 11 September 2009 07:47 Go to previous messageGo to next message
joy_division
Messages: 4617
Registered: February 2005
Location: East Coast USA
Senior Member
sukhvinder_tm wrote on Fri, 11 September 2009 05:17
Hi I also came across this question in a interview but I unfortunately don't have any idea. Can somebody provide his/her expert comments.


It's called AND.
Re: additional condition [message #421890 is a reply to message #421889] Fri, 11 September 2009 07:56 Go to previous messageGo to next message
ThomasG
Messages: 3185
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
I could also be or, though.

My answer would probably have been "By typing them while the input-focus is on the edit window", though. Laughing
Re: additional condition [message #421891 is a reply to message #421890] Fri, 11 September 2009 07:58 Go to previous message
joy_division
Messages: 4617
Registered: February 2005
Location: East Coast USA
Senior Member
ThomasG wrote on Fri, 11 September 2009 08:56
I could also be or, though.



Doh! How I overlooked that is a mystery.
Previous Topic: SQL Query to get date ranges from a list of dates
Next Topic: Filling gaps from another table
Goto Forum:
  


Current Time: Wed Sep 28 10:52:21 CDT 2016

Total time taken to generate the page: 0.16148 seconds