Закрыт

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

Навыки: Oracle, SQL, Управление базами данных, SQL-сервер Microsoft, MySQL

О клиенте:
( 2 отзыв(-а, -ов) ) Hong Kong, Hong Kong

ID проекта: #34293719

44 фрилансеров(-а) готовы выполнить эту работу в среднем за $156

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 Больше

$200 HKD за 4 дней(-я)
(6 отзывов(-а))
5.1
(20 отзывов(-а))
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

$300 HKD за 7 дней(-я)
(21 отзывов(-а))
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

$80 HKD за 1 день
(8 отзывов(-а))
4.1
(12 отзывов(-а))
4.0
(24 отзывов(-а))
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#, Больше

$160 HKD за 7 дней(-я)
(9 отзывов(-а))
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.

$120 HKD за 1 день
(10 отзывов(-а))
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 Больше

$200 HKD за 1 день
(2 отзывов(-а))
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

$100 HKD за 1 день
(8 отзывов(-а))
3.0
Peefect

Hi, I am an expert please discuss with me thanks

$80 HKD за 1 день
(10 отзывов(-а))
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 Больше

$160 HKD за 3 дней(-я)
(10 отзывов(-а))
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 Больше

$80 HKD за 3 дней(-я)
(5 отзывов(-а))
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/ Больше

$230 HKD за 7 дней(-я)
(3 отзывов(-а))
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 Больше

$200 HKD за 1 день
(1 отзыв)
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 Больше

$160 HKD за 7 дней(-я)
(1 отзыв)
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 Больше

$160 HKD за 7 дней(-я)
(1 отзыв)
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!

$100 HKD за 7 дней(-я)
(1 отзыв)
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 Больше

$160 HKD за 7 дней(-я)
(1 отзыв)
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.

$210 HKD за 1 день
(1 отзыв)
0.6