What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 47738 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 is the log shipping?
What happens if date-only values are provided as date and time literals?
Explain what role entity and relationship play in an ER diagram.
What are information schema views?
Is foreign key a primary key?
what is the difference between Delete and Truncate command in SQL
How to receive returning result from a query?
Tell me what are the essential components of sql server service broker?
What are commonly used mssql functions in php?
What do you need to connect php to sql server?
What is importing utility?
How do I find the size of a sql server database?
Explain the properties of a relational table?
Do you think BCNF is better than 2NF & 3NF? Why?
Is it important for a database administrator to understand the operating system and file access?
