Limitations in a query !!

Giganews Newsgroups
Subject: Limitations in a query !!
Posted by:  harsha.21a…@gmail.com
Date: 2 Aug 2006

Hi all there,
  I'm a newbee to this forum. I've a question, is there any limitation
on "IN" clause in select query.
for example :
"SELECT EMP_ID, EMP_NAME FROM EMPLOYEE WHERE EMP_ID IN
('EMP1001','EMP1002','EMP1003', etc, etc, so on)".

I've read at some documentation that there is a limitation for Columns
in a table and i.e. we can have only 1024 columns per table, is this
true?
Plz help me !!

Thanx in advance.

Kind Regards,
Harry

Replies