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
- 49171 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
What are the types of normalization?
What are the different subsets of sql?
What are trace flags?
What are the different types of collation sensitivity?
Explain what is it unwise to create wide clustered index keys?
How to find the source of a table in sql server?
What is database replication? What are the different types of replication you can set up in sql server?
Does transparent data encryption provide encryption when transmitting data across the network?
How to enter date and time literals in ms sql server?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What is the largest component inside a field?
What is mean by candidate key?
What is field with example?
How many primary keys are possible in a table?
What is a fan-out query in SQL Azure?
