1. Selecting all columns but one coderanch.comHi, I have about 30+ columns in my table. I want to select all columns but one column (which has to come from another table). Do I have to specify each column name in the select clause or is there an easier and a better way of doing it? All help appreciated. Harsha [ August 26, 2005: Message edited by: Harsha ... |
2. how to select particular column name coderanch.com |
3. Can I Select column A OR column B ? coderanch.comHi All, Just wondering if this is a possibility. I need to do a pretty complicated select statement, and one of the things I need to do is select a time value. The problem I have is, I need to use the time value in Column A, only if the value in Column B is null, if the value in Column ... |
4. How to parse column data using select?? coderanch.comHi I have a small problem regarding parsing data in a column using only select statement Say there is some data "abc;def;ghi;" in a column which needs to be displayed as abc def ghi using only select statement. I know we can write a procedure to easily do this but i would like to know how it can be done using ... |