Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
sql query help
This is a discussion on sql query help within the SQL forums, part of the Databases category; Dear all. I have table with 250 columns.But i want to retrieve the data from 240 columns only.If i use joins then i have to refer to 240 columns.if i ...
|
|||||||
07-24-2008
|
|||
|
|||
sql query help
Dear all.
I have table with 250 columns.But i want to retrieve the data from 240 columns only.If i use joins then i have to refer to 240 columns.if i use views i requirement changes frequently like neglecting 11th col,123 col etc. Would any one suggest me the solution other than views. Thanx in advance 
|
| Sponsored Links |
|
07-26-2008
|
|||
|
|||
|
Re: sql query help
Quote:
To join two tables you need not specify all 240 columns in join condition. To join n tables you need to specify n-1 join conditions.
|
|
09-13-2008
|
|||
|
|||
|
Re: sql query help
In your question you have written that you have 1 table & that you want to retrieve only 240 columns. So where is the question of join. I think that join is only between two tables or if we have self referential integrity then we may need to join the table with itself. So please clarify...
|
 |
|
«
Raj
|
Rowid and Rownum
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| sql query | max__payne_nishant | SQL | 3 | 09-20-2008 01:43 PM |
| How to get this o/p from the sql query | bhaski | SQL | 4 | 06-21-2008 01:27 AM |
| sql query help... | psuresh1982 | SQL | 6 | 07-23-2007 12:55 AM |
| regarding sql query | psuresh1982 | SQL | 8 | 07-13-2007 03:20 AM |
| Query with C++ | StephenRaj | C and C++ | 1 | 08-14-2006 04:09 AM |
All times are GMT -4. The time now is 04:58 AM.
