From the course: Querying Microsoft SQL Server 2019
Join today to access over 25,300 courses taught by industry experts.
Comparison operators - SQL Server Tutorial
From the course: Querying Microsoft SQL Server 2019
Comparison operators
- [Instructor] The mathematical comparison operators, are extremely important in the design of useful queries. You might not know them by that name, but I'm sure you'll recognize them, once you see them. They're the equals, less than, and greater than symbols, and by combining two different symbols, you can get less than, or equal to, greater than or equal to, and not equal to, which is literally the less than, and greater than symbols together. There are a few that use the exclamation point that you can use, but they're not standard. They're not equal to, not less than, and not greater than, this format isn't common to use, but you might run across them when exploring queries in databases that other people have made. So it's a good idea to be familiar with what they are, I'd recommend sticking with the standard formats, when writing queries in SQL Server. So let's see these in action, in a couple of queries. I'm going…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.