Fermé

Oracle sql query

I would like to improve the existing query that built by others to exclude some data I don’t need

The query will be improved based in the following

select DECODE(RTRIM(TO_CHAR (SYSDATE, 'DAY')),'SATURDAY',4,'SUNDAY',decode(sign(to_number(to_char(sysdate, 'HH24'))-20),0,4,-1,4,count(*)),count(*)) from

Compétences : Oracle, SQL, Administration de Bases de données, Serveur SQL Microsoft, MySQL

Concernant le client :
( 2 commentaires ) Hong Kong, Hong Kong

Nº du projet : #34293719

44 freelances font une offre moyenne de 156 $ pour ce travail

anastasbestdew

Hello, this is Anastasiia from Poland who has 6+ year experience in MERN, Laravel, CI, WordPress, CSS, Bootstrap, HTML, JavaScript, TypeScript., MySQL, Database Administration. I have checked your project description t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% HKD en 4 jours
(6 Commentaires)
5.1
(20 Commentaires)
4.5
TEKSCENT

Hi i have more than 13 years of experience in sql /plsql development and worked in more than 300 projects in oracle/mysql/db2/[login to view URL] discuss your requirement

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% HKD en 7 jours
(21 Commentaires)
4.4
Anilsingh1992

hi I read all details . i am good in sql increase performance. Please send me a message so that we can discuss further. thank you! https://www.freelancer.com/u/Anilsingh1992

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% HKD en 1 jour
(8 Commentaires)
4.1
(12 Commentaires)
4.0
(24 Commentaires)
4.1
krishantha972

Dear Client; I have gone through your project description and as per analysis ready to give you complete work. I am working as senior software engineer with over 10 Years’ experience for software development using c#, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% HKD en 7 jours
(9 Commentaires)
4.1
mohitverma1191

Hi.. I can modify the sql query for you and exclude any data which you don't require. Kindly initiate the chat so that i can start the work asap. Thanks.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% HKD en 1 jour
(10 Commentaires)
3.7
arunkumarragee

♦ PL/SQL Expert ♦ Database Developer ♦ Immediate Start ♦ I’m a Software Engineer with 9+ years of experience in DB development. I’m expertise in multiple databases MYSQL, Oracle, MSSQL, Snowflake and PostgreSQL. I woul Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% HKD en 1 jour
(2 Commentaires)
3.2
noureen23

Hi There, Just gone through your requirement to improve query designed in oracle. I have extensive experience of SQL and oracle. Kindly share details to proceed. Thanks for your time. Regards

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% HKD en 1 jour
(8 Commentaires)
3.0
Peefect

Hi, I am an expert please discuss with me thanks

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% HKD en 1 jour
(10 Commentaires)
2.8
Bhatti1987

I have more than 12 years of experience in Oracle/ SQL Server database modelling, design, development, and Administration. I have worked for database designing and modelling of complex business an efficient way. I hav Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% HKD en 3 jours
(10 Commentaires)
2.9
swaroopy

Hi, I am very good in writing SQL's. I have done similar project and clients are happy with my work. Ping me so that we can discuss more on our project. Thanks in advance and awaiting for you message. I am ready to s Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% HKD en 3 jours
(5 Commentaires)
2.6
croca

Hello Hong Kong, I would like to help improving this query, it would be nice to take a look at the entire SQL query since the provided one was truncated after the FROM part. I have almost 30 years as oracle DBA and PL/ Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% HKD en 7 jours
(3 Commentaires)
2.1
kostyrahi

Hi, I have read your job description carefully, and I jump in to the conclusion that I can handle your issue in no time. I have 10+ years of experience in optimizing query in MySQL, MSSQL, Oracle. Looking forward t Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% HKD en 1 jour
(1 Évaluation)
1.8
SultanMahmud3

I have professional experience to work with Web Applications, Mobile Apps and Desktop Software development. My professional skillfulness: • Spring Boot: I have been working Backend and Frontend with single or Multi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% HKD en 7 jours
(1 Évaluation)
1.9
HKITECHSERVICES

WEBSITE & MOBILE APP EXPERT HERE YES, I am confident to Build your website and mobile appication as per your requirement. I am expertise in PHP/ PYTHON / React/ ReactNative / MySql / Frameworks / Laravel / Codeigni Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% HKD en 7 jours
(1 Évaluation)
0.6
denysdenysivanch

❤️ Hello. I have rich experience in Oracle & database. also I'm very familiar with subquery. I can improve your query as you want. Please contact me to discuss more, looking forward to work with you. Thanks!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% HKD en 7 jours
(1 Évaluation)
0.8
fayyaz09

FAB consultancy services [login to view URL] most importantly we are oracle databases experts like sql server, post gre sql, migration experts ,we experts in databases migration, acro Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% HKD en 7 jours
(1 Évaluation)
1.0
vikashandibag119

Having 7+ yrs development experience in Oracle. Worked on big project. I can handle big script. Worked in many MNCs and big 4 companies.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% HKD en 1 jour
(1 Évaluation)
0.6