Ask a Question related to Coldfusion Database Access, Design and Development.
-
blastbeat #1
Comparing 2 columns in my select
I have 3 columns, name - price1 - price2
I want to compare price1 against price2 during my select and only return the
greatest value to my output.
output would look like, name - finalprice
any ideas?
blastbeat Guest
-
select all columns in a table, save for one
Say a table had 15 columns and I wanted to select 14 of them. Is there a way I could specificy the column I didn't wanted selected instead of... -
SELECT * / Order of Columns
Hey guys, is there a way to re-arrange the order of columns when using SELECT * - I don't normally use SELECT *, but am forced to in a current... -
Comparing 2 values in a SQL Select
Hi Folks - I was wondering if anybody knows how to get a single value result from 2 previous calculated results... Here's my query...... -
Selecting all columns, but in a different order in SELECT statement
Thanks, i thought that was the case... just wanted to confirm it before i started working on it. Alex "Vishal Parkar" <vgparkar@hotmail.com>... -
Pad strings/concatenate columns to simulate data columns in ASP select box with SQL Server 2K
Dale, Cast all the data to fixed character data type in your select statement. For example: select cast(au_id as char(12)) +...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
