5 Replies Latest reply on Oct 30, 2014 11:03 AM by ascheffer

    sql query clarification

    2742751

      I have a table t1 consists of 3 columns(col1,col2,col3).t1 consits of million of rows.I have one excel sheet consists of 1000 rows as below

      sample data  in excel:

      2

      3

      4

      5

      6

      required o/p data in excel.

      2,y

      3,y

      4,y

      5,y

      6,n

      basically i have to to check whether value in present in table t1 or not.if present i need to populate y else n. currently i am doing manually for each and every value.

      select * from t1 where col2=2.

      if record is present i will update excel sheet as y which is a difficult approach.is there any sql query to get required required o/p so that i can copy the result from sql to excel.