TSQL Beginners Challenge 5 - Search the closest number in the series - Solution to TSQL Beginners Challenge5

Getting Started with Adobe After Effects - Part 6: Motion Blur


	TSQL Beginners Challenges

Upload Image

Close it

Select File

This challenge has been taken from a forum. The challenge is all about searching the closest number in a collection of numbers. Let’s have a look into the sample data.


	Like

Invite Friends

TSQL Beginners Challenge 5 - Search the closest number in the series

Home · Challenge Details · Comments · Solutions · Fans (49) · Preferences

Solution to TSQL Beginners Challenge5

Oct 28 2011 9:46AM by chumil

Solution to TSQL Beginners Challenge5

Select top 1 Numbers from @T
order by ABS(Numbers - @NumberToSearch)

Tags:

chumil

2114 · 0% · 6

Liked


Post this to my facebook wall
Tweet this
Like this


	Submit

Your Comment

Sign Up or Login to post a comment.

TSQL Beginners Challenge 5 - Search the closest number in the series

Solution to TSQL Beginners Challenge5

Your Comment