Find Jobs
Hire Freelancers

Dynamic Sql Query

₹600-1500 INR

已完成
已发布大约 4 年前

₹600-1500 INR

货到付款
Hello, I wish to know the sql query to print out the list of students from a database table name 'testnew' whose results of all the papers have been uploaded in the table ..in the example. I have shown result of 3 students.. There is one paper_is of Tushar which is not yet filled (so i want to remove this student from resulting data from query) .. Sachin , whose all papers marks are uploaded (so i want to include him in the result).. and about Rakesh . all the paper results of him are uploaded in 'testnew 'table but one of his paper_id is not there in 'testnew' table.. you can check from another table 'exam_form_data' that he had appeared for 3 exams but only 2 paper id details are filled in 'testnew' (So I want to exclude this type of student too) Help me build the final query .. and I have attached the screenshot of sample tables from database
项目 ID: 23441559

关于此项目

21提案
远程项目
活跃4 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
I am an experienced SQL developer. Your query is a common one, but not easiest one. It has a tricky part but it can be done. Regards Santiago
₹900 INR 在1天之内
5.0 (1条评论)
0.2
0.2
21威客以平均价₹1,195 INR来参与此工作竞价
用户头像
Proposal - You can expect any kind of work on SQL from me. Let me know if you want to discuss further. I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database/Datawarehouse - SQL Server, Oracle, MySQL BI - Microsoft MSBI and Informatica ETL Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... Cloud - Azure (Paas and IaaS) My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
₹2,250 INR 在1天之内
5.0 (24条评论)
4.8
4.8
用户头像
Hi I will make this query right now thanks bila l
₹1,200 INR 在1天之内
4.6 (17条评论)
4.4
4.4
用户头像
Hi There, I can build sql query as per your requirement and you will get desired result. I can build query within hour and can start immediate. Looking forward to discuss. Thanks
₹1,500 INR 在1天之内
4.7 (6条评论)
3.9
3.9
用户头像
Hi, I am a UK based SQL developer with over a decade in the industry. I can assist you in the completion of your SQL query. Please let me know if you require my assistance. Kind regards, Tom.
₹1,150 INR 在7天之内
5.0 (3条评论)
2.9
2.9
用户头像
Hi. I  have more then 10 years of experience in SQL Server databse development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performance tuning. I am also good for BI part like SSIS, SSRS and SSAS. I have attached my profile.  I am immediate available to join.
₹1,750 INR 在1天之内
5.0 (3条评论)
1.8
1.8
用户头像
Hello, I can prepare query for you right now. Looking forward to hear from you. I am expert PHP developer. Thanks
₹1,000 INR 在1天之内
5.0 (1条评论)
1.4
1.4
用户头像
I am database developer and having experience of 2 years. I have done database projects. I will complete your task according to your requirements
₹800 INR 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
I am working as freelancer and I have relevant skills and experience you are looking for. Let me know if I can do your work. Relevant Skills and Experience I am working as freelancer and I have relevant skills and experience you are looking for. Let me know if I can do your work.
₹1,300 INR 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hello, i have read your requirements, i really confident that i i can finish all works effectively because of my experinece in computer science. let me introduce myself, i am a software engineer who has 5+ years experience, i usually build some big projects like ERP, GIS, HRIS etc. you won't regret if you choose me, i will give you some proofs if needed. P.S i am new freelancer. Please give me a try.
₹1,000 INR 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hello, I am a professional C# .Net Developer having 3 years of experience. I have ready your requirements and I can help you with your work . My skills set includes Asp.Net MVC,.Net core and Web Api's and SQL SERVER.
₹1,250 INR 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
ello, Greetings of the day!!! We have understood your error. We have a great expertise PHP and Databases. We can fix your error. We do have more than 10 years of expertise in the relevant field. We do have more than 10 years of expertise in Web hosting, Server Setup, Server Configuration, Migration, etc We are also a website hosting service provider and also you can visit us our website datanethosting.com. We have strong knowledge over: * Website migration, Cpanel, WordPress, java, PHP, Mailing server, MYSQL ,MSSQL. * WordPress themeing, Plugin Development, Magento, Zimbra, Apache, SSL, etc. We will complete this job within your estimated time. You can be assured of a quality communication and the quality of the work provided from our end. Looking forward to discuss.
₹1,050 INR 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi, It's really simple query. We can do this. Using some concepts of joins and some other techniques we can solve this in a convenient way!
₹1,050 INR 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi I have good knowledge in SQL over 9 years. I will assist you query completion. Regards, Micheal
₹1,250 INR 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
I am developer and i have experience in working with complex data to retrieve the results is particular formats using complex SQL queries. I have been doing very complex queries in sql, oracle, mysql, etc.
₹1,050 INR 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
I can build the Sql query to get the desired result. I have experience in this Php admin panel. i have build the website usjng this pannel
₹1,050 INR 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
I have good experience in developing SQL queries. I can deliver you results in a day. Looking forward to connect and discuss further about the problem.
₹1,150 INR 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
hi , I have very good knowledge on sql server and ssis and ssrs I have to complete work within one day.
₹850 INR 在1天之内
0.0 (0条评论)
0.0
0.0

关于客户

INDIA的国旗
India
5.0
3
付款方式已验证
会员自10月 3, 2015起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。