Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What does > 0 mean in SQL?

I have the following SQL statement. Please tell me if my translation of it is accurate. I'm using MS SQL Server 2008. Thanks

(bld_sqft > 0 OR bld_area > 0)

My translation

bld_sqft > 0 OR bld_area > 0
like image 383
dido Avatar asked Nov 02 '12 15:11

dido


People also ask

What does the fox say Meaning?

Speaking of the meaning of the song, Vegard characterizes it as coming from "a genuine wonder of what the fox says, because we didn't know". Although interpreted by some commentators as a reference to the furry fandom, the brothers have stated they did not know about its existence when producing "The Fox".

What does a real fox say?

One of the most common fox vocalizations is a raspy bark. Scientists believe foxes use this barking sound to identify themselves and communicate with other foxes. Another eerie fox vocalization is a type of high-pitched howl that's almost like a scream.

How can I identify a song by sound?

On your phone, touch and hold the Home button or say "Hey Google." Ask "What's this song?" Play a song or hum, whistle, or sing the melody of a song. Hum, whistle, or sing: Google Assistant will identify potential matches for the song.


2 Answers

&gt; is an HTML entity (typically used because HTML uses <> for markup), that is not valid SQL and it should not run unless it is being translated to > before being sent to SQL Server.

See http://dev.w3.org/html5/html-author/charref for information about HTML entities.

like image 170
Cade Roux Avatar answered Oct 15 '22 09:10

Cade Roux


Where are you getting this SQL statement? You are right that > translates to the greater than symbol, but it was encoded to the entity character reference. It is almost as if the encoded value was being treated literally when displayed on a web page.

[EDIT] As you can see, when I typed that symbol, it actually rendered as a > symbol in my post...

A good hint is if you see the ampersand (&) followed by two to four characters then a semi-colon, it was supposed to render differently:

http://www.htmlhelp.com/reference/html40/entities/special.html [/EDIT]

like image 27
AceCorban Avatar answered Oct 15 '22 09:10

AceCorban