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
- 49295 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
Explain log shipping?
How do you Implement SSIS Packages in your Project?
What are the different type of replication in sql server?
How to identify current user in ssrs report?
define and explain the differences between clustered and non-clustered indexes.
Can we use trigger new in before insert?
What are sql servers used for?
What are key constraints?
please differentiate between delete and truncate?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
what is the difference between Tabular and Matrix report?
What is DCL?
Tell me what are cursors and when they are useful?
Difference between 2NF &3NF ?
Explain few examples of RDBMS?
