Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 49899 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / kranthi kiran
I am learning SQL Basics..So If my Answer is wrong Plz do
reply to tht,
In the First Query Where 1=1 implies Show all where The
first coloum element is equal to 1
and second query show all from table
| Is This Answer Correct ? | 4 Yes | 40 No |
Post New Answer View All Answers
last function used in MS Access to convert sql what function will use in sql
What is the difference between system objects and user objects?
What stored by the msdb?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What is the security principal at the database level that represents your session?
How can I change procedure name in sql server?
Define left outer join?
Are null values the same as that of zero or a blank space?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Which language is supported by sql server?
What is meant by referential integrity?
How to generate create function script on an existing function?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
What is a view in sql?
plss anybody specify tha constrian management system in dbms
