ignore some values in insert into select from sql stament
Posted
by nitroxn
on Stack Overflow
See other posts from Stack Overflow
or by nitroxn
Published on 2010-03-18T15:16:00Z
Indexed on
2010/03/18
15:21 UTC
Read the original article
Hit count: 195
Suppose that I have a Table Symbols(Symbol, Value) and a Table SymbolValues (Symbol, Value) which contains a list of values for the symbol. How to choose maximum values fromt he SymbolValues table and insert into Symbols table. For Example, The SymbolValues Table has following values
A 1
A 2
A 3
B 6
B 7
Then only A 3 and B 7 should be inserted in the Symbols table.
Is this possible using insert into select statement.
Thanks
© Stack Overflow or respective owner