With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.
Course Of The Month
2 days, 10 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Help in Understanding a SQL Query
Posted on 2016-11-11
Hi guys,
Can you please help me understand this query
What does Select 42 means?
regards
Can you please help me understand this query
SELECT Point.STAsText() AS Wkt
FROM AddressSearchString AS S
WHERE NOT EXISTS (SELECT 42
FROM [PhysicalSpace].[LocationShapes]
WHERE S.Point.STDistance(ShapeData) < 3.0 AND [IsPoint] = 1)
GROUP BY Point.STAsText()
What does Select 42 means?
regards
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3
2-
2
7 Comments
Active today
What does Select 42 means?That's a constant. It could be anything since what's being returned by that SELECT doesn't have any effect on the main SELECT (you aren't comparing columns there).
Typically you'll see there a NULL, * or 1 but 42 is somehow odd but has the same purpose.
Active 1 day ago
42 is just a constant , you can put any value there. Normally people put 1 there. Exists just checks whether you are returning any row. So for any row we can return any value which is a constant value.
Now if you return column values then that might slow the performance of the query and the engine has to return data from the table to the outer query.
So constant inside of a exists clause help as we are not returning the column values, Engine work a bit less..:)
Hope it helps !
Now if you return column values then that might slow the performance of the query and the engine has to return data from the table to the outer query.
So constant inside of a exists clause help as we are not returning the column values, Engine work a bit less..:)
SELECT Point.STAsText() AS Wkt
FROM AddressSearchString AS S
WHERE NOT EXISTS (SELECT 42
FROM [PhysicalSpace].[LocationShapes]
WHERE S.Point.STDistance(ShapeData) < 3.0 AND [IsPoint] = 1)
GROUP BY Point.STAsText()
Hope it helps !
Active 1 day ago
Does this mean that there is no purpose of subquery here as it will always return null as 42 doesn't exist in the subquery table?
Active 1 day ago
No there is purpose , It is used in the where clause. In this case we need to take results where we should NOT have any rows from the Inner query.
Active today
To be honest all query seems very odd to me. You have 2 tables and there's no apparent connection between them.
Is the following query returning the same rows as the original one?
Is the following query returning the same rows as the original one?
SELECT Point.STAsText() AS Wkt
FROM AddressSearchString AS S
WHERE S.Point.STDistance(ShapeData) < 3.0
GROUP BY Point.STAsText()
Active today
Humm, maybe I was too fast. Those functions are Geography functions and then this might make sense so ignore my last comment, please.
What that query is doing is returning all records where the distance is greater than 3.0 (I'm not sure which metric system is being used here so can be miles or kms or even meters).
What that query is doing is returning all records where the distance is greater than 3.0 (I'm not sure which metric system is being used here so can be miles or kms or even meters).
Featured Post
With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL).
Depending on business requirements, a single Stored Procedure can return differe…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses
Course of the Month2 days, 10 hours left to enroll
695 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.