0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

CREATE TABLE #MyTable (EmpID INT,  Skills VARCHAR(500))


 INSERT INTO #MyTable VALUES (1  ,   'C,C++,Oracle'),
 (2    ,   'Java,JavaScript,PHP'),
 (3   ,   'C,C++,Oracle'),
( 4  ,   'JavaScript,C++,ASP'),
 (5   ,   'C,C++,JavaScript')

SELECT *
FROM 
(
	SELECT *
		,CASE WHEN Skills LIKE '%Java%' THEN 0 ELSE 1 END AS Rnk 
	FROM #MyTable
) T
ORDER BY rnk,EmpID


DROP TABLE #MyTable

fork query

edited aug 15 22

created aug 13 13 anonymous