i want to make a matrix query which would return .....

[adnan737]

i'm a biginner in sql and want to make a matrix query using just group functions and comparison operators, which would return three max and min. sal in emp table.

 

[tlbroadbent]

You can use a UNION query and the TOP predicate to get the result you want.

--Get three maximum salaries
SELECT TOP 3 EmpID, EmpName, Sal
FROM Emp
ORDER By Sal Desc

UNION ALL

--Get three minimum salaries
SELECT TOP 3 EmpID, EmpName, Sal
FROM Emp
ORDER By Sal Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm