SQLServerCentral » Latest topics
a sub query filter
is it possible to dynamically find the row containing the largest numeric value to return only one row from each group of records in a sub query?
select * from table1 t1 inner join table2 t2 on t1.no = t2.no where t2.level = (select (the highest
select * from table1 t1 inner join table2 t2 on t1.no = t2.no where t2.level = (select (the highest
No comments:
Post a Comment