Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Strange T-SQL Operator Syntax from Blog Posts - SQLServerCentral

Anonymous

1 min read
09 Nov 2020

0 Likes
0 Comments
669 Views

article-image

I can’t remember where I saw this, but it made an interesting Question of the Day:

select *

from Sales

where Profit !< 10000;

I had never seen anything like this, in all my years of working in C, C++, Java, Lisp, APL, Pascal, Fortran, VB, C#, SQL, and more. However, there are apparently a few operators that I’ve never used:

!<
!>

These are the not less than and not greater than.

Weird, though I guess this makes sense. Personally, I think restructuring as greater than or equal to instead of not less than makes perfect sense.

The post Strange T-SQL Operator Syntax appeared first on SQLServerCentral.

Like
Save for later
Comment

0 Likes
0 Comments
669 Views

Recommendations for you

Fundamentals of Object-Oriented Programming - C++

Fundamentals of Object-Oriented Programming - C++

Feb 2023 7hrs 6mins

Video

R$49.99 ~~R$167.99~~

Hands-On Reinforcement Learning with Python

Hands-On Reinforcement Learning with Python

Jun 2018 318 pages

eBook

R$49.99 ~~R$173.99~~

Managing Kubernetes Resources Using Helm

Managing Kubernetes Resources Using Helm

Sep 2022 310 pages

eBook

R$49.99 ~~R$231.99~~

Implementing Event-Driven Microservices Architecture in .NET 7

Implementing Event-Driven Microservices Architecture in .NET 7

Mar 2023 326 pages

eBook

R$49.99 ~~R$200.99~~

OpenGL 4 Shading Language Cookbook

OpenGL 4 Shading Language Cookbook

Sep 2018 472 pages

eBook

R$49.99 ~~R$218.99~~

Raspberry Pi and MQTT Essentials

Raspberry Pi and MQTT Essentials

Sep 2022 272 pages

eBook

R$49.99 ~~R$164.99~~

The Software Developer's Guide to Linux

The Software Developer's Guide to Linux

Jan 2024 300 pages

eBook

R$49.99 ~~R$178.99~~

Building Python Microservices with FastAPI

Building Python Microservices with FastAPI

Aug 2022 420 pages

eBook

R$49.99 ~~R$209.99~~

Hands-On Design Patterns with C++

Hands-On Design Patterns with C++

Jul 2023 626 pages

eBook

R$49.99 ~~R$218.99~~

LLM Engineer's Handbook

LLM Engineer's Handbook

Oct 2024 522 pages

eBook

R$49.99 ~~R$267.99~~

Comments (0)

No comments for this article yet!