SQL Query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nitindel
    New Member
    • Dec 2007
    • 67

    SQL Query

    Hi All,


    What is the output of this SQL Query.??
    What does it Do....
    Do tell me other queries related like this Consttants...


    Thanks ,
    Nitin
    Software Engineer
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    Originally posted by nitindel
    Hi All,


    What is the output of this SQL Query.??
    What does it Do....
    Do tell me other queries related like this Consttants...


    Thanks ,
    Nitin
    Software Engineer

    Where's the query?

    -- CK

    Comment

    • nitindel
      New Member
      • Dec 2007
      • 67

      #3
      Select * from Emp where 1=1

      Comment

      • debasisdas
        Recognized Expert Expert
        • Dec 2006
        • 8119

        #4
        There is no use of such a query ,that will simply return all the records from the table.

        Comment

        • nitindel
          New Member
          • Dec 2007
          • 67

          #5
          Actually i was using that query because i have to append the query and if condition ...
          the above query will return all the records like select * from emp but addding where alause is necessary to append it to the new query in If condition of my Code.


          Thanks a lot...

          Nitin Sharma
          Software Engineer

          Comment

          Working...