In SQL Server, let's say I have a table `Mytable` with a composite primary key `[ColA, ColB, ColC]`. 
I would like to do the following pseudo-query: 

```
select * from Mytable where (ColA,ColB,ColC) > (SomeValA,SomeValB,SomeValC)

```

Is this possible somehow?

EDIT:
Example:

```
create table Mytable (a integer, b integer, c integer);
insert into Mytable values (1,1,1),(1,1,2),(1,2,1),(2,1,1);

```

Doing `select * from Mytable where (a,b,c) > (1,1,2)` should return rows (1,2,1) and (2,1,1) 

EDIT 2: Let me rephrase:
If a total order function can be defined on an ordered subset of the columns of a table then is there a way I can query the table using this order function as a predicate?