국내주식 / 일본주식 / 개발자이야기

C#

using System;

public class Solution {
    public string solution(string s, string skip, int index) {
        string answer = "";
        
        for(int i = 0;i<s.Length;i++)
        {
            int asc = Convert.ToInt32(s[i]);
            
            for(int k = 0;k<index;k++)
            {
                asc++;
                if(asc > 122)
                {
                    asc = asc - 26;
                }
                
                for(int j = 0;j<skip.Length;j++)
                {
                    if(skip.Contains((char)asc))
                    {
                        asc++;
                        if(asc > 122)
                        {
                            asc = asc - 26;
                        }
                    }
                }
            }
        
            answer += (char)asc;
        }
        
        return answer;
    }
}

////////////////

자바

class Solution {
    public String solution(String s, String skip, int index) {
        StringBuilder answer = new StringBuilder();

        for (char letter : s.toCharArray()) 
        {
            char temp = letter;
            int idx = 0;
            
            while (idx < index) 
            {
                temp = temp == 'z' ? 'a' : (char) (temp + 1);
                
                if (!skip.contains(String.valueOf(temp))) 
                {
                    idx += 1;
                }
            }
            answer.append(temp);
        }

        return answer.toString();
    }
}

class Solution {
    public String solution(String s, String skip, int index) {
        String answer = "";

        for (char c : s.toCharArray()) 
        {
            for (int i = index; i > 0; i--) 
            {
                c++;
                if (c > 122) c -= 26;
                while (skip.contains(String.valueOf(c))) 
                {
                    c++;
                    if (c > 122) c -= 26;
                }
            }
            answer += c;
        }
        return answer;
    }
}

https://m.blog.naver.com/gboarder/90015619564

-- 코드를 입력하세요

SELECT DISTINCT T1.CART_ID

from CART_PRODUCTS T1,

CART_PRODUCTS T2

where

T1.CART_ID = T2.CART_ID and

T1.NAME = 'Yogurt' and

T2.NAME = 'Milk'

order by T1.CART_ID

​

/// 셀프 조인을 이용하는 방법도 있고

​

SELECT CART_ID

FROM CART_PRODUCTS

WHERE NAME = 'Yogurt'

INTERSECT

SELECT CART_ID

FROM CART_PRODUCTS

WHERE NAME = 'Milk'

ORDER BY CART_ID

​

/// INTERSECT를 이용하는 법도 있다.

intersect는 교집합