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
 General SQL Server Forums
 New to SQL Server Programming
 Filters

Author  Topic 

prasaditc55
Starting Member

8 Posts

Posted - 2012-08-23 : 06:29:22
Hi,

I want to do filtering from sql resultset.. can anyone pls help me out.

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2012-08-23 : 07:16:24
Use WHERE (or HAVING if aggregates are used) clause to filter records.

--------------------------
http://connectsql.blogspot.com/
Go to Top of Page

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-08-23 : 07:17:48
You can do filtering using WHERE clause in the query that generates the result set. There is a simple example here: http://msdn.microsoft.com/en-us/library/ms173294.aspx

Or are you asking about filtering at a client program, front-end or reporting site? If you are, post more details about what kind of client with some examples.
Go to Top of Page
   

- Advertisement -