What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
Answer Posted / hasan
Both are same .
They r showing all results.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is the full form of dql?
We need to perform what steps in the following order to work with a cursor?
How to insert stored procedure result into temporary table?
What are database states in ms sql server?
Can we use having clause without group by?
What is the default value of an integer data type in sql server 2005?
How do I find sql server instance name?
Give the query of getting last two records from the table in SQL SERVER?
What are subquery and its properties?
After removing a table from database, what other related objects have to be dropped explicitly?
What is the recursive stored procedure in sql server?
How can you list all the table constraints in a database?
Do you know concepts and capabilities of sql server?
Do you know exporting and importing utility?
How do I start sql server 2017?