Showing specific results - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Showing specific results

Author

Topic

mkusza1
Starting Member

12 Posts

Posted - 2008-03-11 : 09:56:31

"SELECT [ID], [Application], [Section], [Part Number], [Description], [Part Code], [Revision], [Hyperlink] FROM Catalog WHERE [ID] IS >25 BY [Application], [Section] ASC"

That is what i would like it to say, but not sure how to achieve that. If you could please advise it would be greatly appreciated. Thanks

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2008-03-11 : 10:04:17

Remove the word "IS", the > symbol means literally "is greater than"

WHERE [ID] >25

Poor planning on your part does not constitute an emergency on my part.

mkusza1
Starting Member

12 Posts

Posted - 2008-03-11 : 10:28:12

And to do a record say in the middle >25<70 or can i simple say between 25-70? new to all this appreciate the help

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-03-11 : 10:31:18

[code]Where [ID] > 25 and [ID] < 70[/code]

Between means you want to include both upper and lower bounds.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-03-11 : 10:31:45

[code]SELECT ID,
Application,
Section,
[Part Number],
Description,
[Part Code],
Revision,
Hyperlink
FROM Catalog
WHERE ID > 25
ORDER BY Application,
Section

SELECT ID,
Application,
Section,
[Part Number],
Description,
[Part Code],
Revision,
Hyperlink
FROM Catalog
WHERE ID > 25
AND ID < 50
ORDER BY Application,
Section

SELECT ID,
Application,
Section,
[Part Number],
Description,
[Part Code],
Revision,
Hyperlink
FROM Catalog
WHERE ID < 13
OR ID > 50
ORDER BY Application,
Section[/code]

E 12°55'05.25"
N 56°04'39.16"

mkusza1
Starting Member

12 Posts

Posted - 2008-03-11 : 10:33:52

Thank you all very much.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources