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
- 50375 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 scheduled tasks in sql server?
What is key set driven?
What Is Rdbms?
what is a deadlock? : Sql server database administration
Define self join?
What functions can a view be used to performed?
how can u get last observation in an unknown dataset ?
Can you name a few encryption mechanisms in sql server?
What are key constraints?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
Does transparent data encryption provide encryption when transmitting data across the network?
What are Spatial data types in SQL Server 2008
What happens when converting big values to numeric data types?
What is the command to change the recovery model?
How to rename an existing column with sql server management studio?
