|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
I want to select all fields from my SQL table apart from one. Does anybody know of a way i can select all fields apart from one, or two, or three?
Or do you have to enter a full select statement as in select field1, field2, field3, field4 etc etc from tbltable. I have about 40 fields in a table and just want to select certain ones without making a view. Thanks for you help in advanced |
|
#2
|
|||
|
|||
|
Well to the best of my knowledge (which is exceedingly limited) unless you use "select *" then you're gonna have to enter every field.
|
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > SQL Select statement |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|