SQL Tricky Interview Question | Remove Alphabets in SQL | Only Numbers in SQL | Regexp_Replace

preview_player
Показать описание
#sql #sqltutorial #sqlinterviewquestionsandanswers #sqllearning #snowflake #snowflaketraining

SQL Tricky Interview Question :
Write SQL Query to get Only Numbers in SQL

Trim
Replace
Regexp_Replace

CREATE OR REPLACE TABLE TEST AS
SELECT 'INR500' PRICE FROM DUAL
UNION ALL
SELECT 'INR 600' FROM DUAL
UNION ALL
SELECT '690IN R66' FROM DUAL
UNION ALL
SELECT '757EURO' FROM DUAL
UNION ALL
SELECT ' 676INR' FROM DUAL
UNION ALL
SELECT 'DLR77.99' FROM DUAL
Рекомендации по теме
Комментарии
Автор

Hi sir example of Sjsjs.T17282 How separate this (.T17282)

rukshanab
Автор

Sir I learnt MS SQL Server
I want to work as a SQL developer
Could you please help me which courses to be learn and please guide me how to know to get real time project

mohankrishnasiliveru
Автор

i need solution in my sql, my version doesnt support reg_exp

pradeepvadlakonda
visit shbcf.ru