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 are the different types of backups that exist?
What happens if the update subquery returns no rows in ms sql server?
Difference between DELETE and TRUNCATE?
How to create sub reports?
what authentication modes does sql server support? : Sql server database administration
What command do we use to rename a database?
What is ms sql server service broker?
what types of replication are supported in sql server? : Sql server database administration
How to modify the underlying query of an existing view?
What type of locking occurs during the snapshot generation? : sql server replication
What is a full text index?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
Which data type columns are the best candidates for full-text indexing?
What is Federation Root Database?
What is table value parameters (tvp)?