Another way of doing a select statement

Question

Another way of doing a select statement

.Netter

SSCrazy

Points: 2476
More actions
May 1, 2012 at 1:08 pm

#392163

Iv seen this done multiple ways but i cant remember them sadly,
Im use to doing
Select Firstname, Surname, Age, HairColour, EyeColour
From Persons
where Firstname = 'Mark'
Can someone show me another way of doing this? I think it starts with Where <something> in
Im not sure......

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

.Netter (5/1/2012)
Iv seen this done multiple ways but i cant remember them sadly,
Im use to doing
Select Firstname, Surname, Age, HairColour, EyeColour
From Persons
where Firstname = 'Mark'
Can someone show me another way of doing this? I think it starts with Where <something> in
Im not sure......

Would help to know what it is you are trying to accomplish.

.Netter SSCrazy Points: 2476 More actions · Answer 2

.Netter

SSCrazy

Points: 2476

May 1, 2012 at 1:12 pm

#1482053

Purely another way of doing it

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

If all you are looking for is 'Mark' then the way you are doing it is the correct way.

.Netter SSCrazy Points: 2476 More actions · Answer 4

I was just curious thats all, because i saw a select statement few months back that had a "in" in it, followed by brackets etc

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

If you are that curious, have tried looking in Books Online? It is a very good reference for MS SQL Server.

.Netter SSCrazy Points: 2476 More actions · Answer 6

Iv spent the past 30 minutes browsing the new trying to find examples of different ways you can do a select statement etc but iv just come across one, its only small but it gives me the information i need 🙂

Sean Lange SSC Guru Points: 286590 More actions · Answer 7

Searching this can be of difficult if you don't know what you are looking for, which I suspect you probably a bit uncertain. Here is the BOL link for the WHERE clause. http://msdn.microsoft.com/en-us/library/ms188047%28v=sql.105%29.aspx

This should explain what you are asking plus a couple dozen other questions you didn't know you needed an answer for yet.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 8

And I'm just curious why. Other than curiosity, what is there you are trying to accomplish?

.Netter SSCrazy Points: 2476 More actions · Answer 9

.Netter

SSCrazy

Points: 2476

May 1, 2012 at 1:31 pm

#1482075

Thanks for the link ill take a look 😀

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 10

IN is for when you have a list of things that you want to compare, not a single name. So if you wanted Mark, William and James, you could do this:

WHERE Name = 'Mark' OR Name = 'William' OR Name = 'James'

or you could do this:

WHERE Name IN ('Mark', 'William', 'James')

They are completely synonymous and are executed in exactly the same way.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass