If statement in SQL

Can I use a Neted If statement, or similar statement in SQL??
If so, how????
traceysmallAsked:
Who is Participating?
 
kretzschmarConnect With a Mentor Commented:
ok,
no sql for this,
you need to iterate
through the dataset

explain: whats i,j, write row?
0
 
kretzschmarCommented:
explain,
what database you use and what you want.
0
 
traceysmallAuthor Commented:
I've developed a database in Borland Delphi 2.0's Database Desktop.
0
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
kretzschmarCommented:
dbase, paradox, oracle, informix ...?
0
 
traceysmallAuthor Commented:
paradox
0
 
kretzschmarCommented:
what kind of 'if' (a sample) ?
0
 
traceysmallAuthor Commented:
Just a sample in simple English:
If col1(i) = col2(j) then
  write row (from col1 ... col12)
If col1(i) > col2(j) but < col(i+1)     then write row (from col2 ... col12)
0
 
traceysmallAuthor Commented:
thanks, that's all I wanted to know - i was just looking for an easy way out - I'll try to iterate through the dataset.
0
 
kretzschmarCommented:
well ok,
thanks for accepting
good luck

meikl

0
All Courses

From novice to tech pro — start learning today.