Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
[SQLS]-Split and update a column
create table t (a varchar(32)); insert into t (a) values ('adridi_amaris.com'); insert into t (a) values ('jmoretti_amaris.com'); select * from t update t set a = left(a, charindex('_',a+'_')-1) ; select * from t;
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Remove duplicates with in 10 min
emp 4
q
Hotel
Employee Department Interview Questions
Arif Secoond Query
SQL for beginners( defined with errors while enforcing constraints)
db2
SaLLa
sum vs count with multiple options in group by clause
Please log in to post a comment.