Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by kiranjasti
-
how to find all customers with the same first and last name
Hi rafaelos, If Possible can u give ur Table Structure with sample data then we can make u clear about this. Regards Kiran- kiranjasti
- Post #6
- Forum: ANSI_SQL
-
how to find all customers with the same first and last name
Hi, If Your Table contains seperate first name and last name columns then the following Query will solve ur problem SELECT customerid FROM customertable WHERE firstnamecolumn = secondnamecolumn; This will fetch u all the customers who have firstname and secondname same. If this is not ur...- kiranjasti
- Post #2
- Forum: ANSI_SQL
-
Displaying No.Of Days Experience
Hi Buddies, I have a small doubt. Can any of u help me out in this regard I hope Everybody knows about the EMP Table. I want to use the hiredate of the employee. My requirement is to display his/her experience in days For Example If he has 400 days of experience then my output Should...- kiranjasti
- Thread
- Replies: 1
- Forum: ANSI_SQL
-
misuse of LONG datatype in an INSERT command
Dear Cantor, A value of datatype LONG was used in a function or in a DISTINCT, WHERE, CONNECT BY, GROUP BY, or ORDER BY clause. A LONG value can only be used in a SELECT clause. In your DataLink u might have used CONNECT BY SO u r getting the error.So u cannot copy LONG value across...- kiranjasti
- Post #3
- Forum: ANSI_SQL
