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 a fan-out query in SQL Azure?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
How fixed length strings are truncated and padded?
How to attach adventureworkslt physical files to the server?
What is collation sensitivity? Explain different types.
What is the difference between lock, block and deadlock? : sql server database administration
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Can you pass expressions to stored procedure parameters?
What is single-user mode?
what's the difference between a primary key and a unique key? : Sql server database administration
What is 5nf in normalization form?
Define Joins?
What is row_number()?
What are the requirements to use odbc connections in php scripts?
What new changes are being made in SQL Server?