Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

SQL SELECT challenge...

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • ADFO
    replied
    SQL SELECT challenge...

    My DB contains approx 500 recs, all uniquely numbered with a 3 char key field. I want to make a SELECT that produces a sorted (by key) subfile. The challenge is to have record '770's data be accumulated to record '390's data and the sum presented as if it was '390'. '770' shal not be displayed anymore. How can I accomplish this in a SQL-statement ?

    Leave a comment:


  • Guest's Avatar
    Guest started a topic SQL SELECT challenge...

    SQL SELECT challenge...

    SELECT CASE WHEN keyfld = '770' THEN '390' ELSE keyfld END AS keyfld
Working...
X