Help required for Microsoft clustering.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hai,
I have a Relational table named Candidate.

the fields of that table are

candidateid name skills expinyears

1 aaa java 2

2 bbb .net 1

3 ccc java 3

4 ddd .net 3

5 eee .net 4

''''''''''''''''''''''''
......................................



like this i have a table.

from this i have to group based on experience and skills.


my requirement is to find


1.candidate with java skills and lessthan 2 years exp.
2.candidate with java skills and greater 2 years exp.
3.candidate with .net skills and greater 2 years exp.
4.candidate with .net skills and lessthan 2 years exp.



how can i do that??????


pls help me.

thanks,
kannan

--
Message posted via http://www.sqlmonster.com
.

Relevant Pages