The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
COURSE of the MONTH
13 days, 12 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 today
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 today
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 today
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
Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
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 Month13 days, 12 hours left to enroll
801 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.