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
- 49814 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 format parameter in ssrs?
What is forward - only cursors / read only cursor?
How we can refresh the view?
What happens if an integer is too big for int date type?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
ow to bring suspect mode datbase online from scratch
Write a SQL query to make a column as unique?
What is table constraint?
What is logon trigger?
Explain the usage of floor function in sql server.
To which devices can a backup be created and where should these devices be located? : sql server management studio
What are different type of Collation Sensitivity?
What the class forname () does?
What is sql server query analyzer?
What is use of dbcc commands?
