CUBE OR ROLLUP HERE WE USE? PLS HELP ME!!

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Tony Webster SSChasing Mays Points: 610 More actions · Answer 1

Something like:

SELECT

CASE WHEN [Employee ID] = (SELECT MIN([Employee ID]) FROM emp e

WHERE e.[Department ID] = emp.[Department ID])

THEN CAST([Department ID] AS varchar(10))

ELSE ''

END AS [Department],

[Employee Name],

[Employee ID]

from emp

ORDER BY [Department ID], [Employee ID]

Important that you call the first field something other than [Department ID],

so it can sort by the original department ID field. The first field gets cast to

a string so you can send a blank rather than just a NULL if it was an integer.

Papillon Hall of Fame Points: 3303 More actions · Answer 2

Hello friends!!!!!

The solution which Tony Webster has given that worked out!!!!

Thanks Tony!!!!

Shashank

Regards,

Papillon

Note: Employee ID is Primary Key
Department ID	Employee Name	Employee ID
101	Mack	A1001
101	Krish	A1003
101	Harsh	A1004
101	Marry	A1008
103	Susam	A1016
103	Mohan	A1021
103	Gayle	A1033
104	King	A1000
105	Potter	A1005
105	Hussain	A1006