Need a SQL developer

Hello Ashish, Please let me know your business problem so that I can give you exact SQL. Here are few SQLs: Case#1: When you need to get the result of both values if exists in table: SQL: Select * from TestTable where data IN ('test', 'test1') Case#1: When you need to get the result of both or either values: SQL: Select * from TestTable where data = 'test OR data = 'test1' Please elaborate your requirement for SQL Development so that I can understand the scope of work and can provide you a proper proposal of cost and time. Or, you are looking for a developer on monthly basis. Please confirm. Please ping me for further discussion. Looking forward for your reply. Thanks & Regards, Anshulika Bansal

Select * from TestTable where data = 'test' and data = 'test1' : This query syntax is correct. But no results. Because incorrect operator "and" was used. You must change operator "and" to "or". Hi, nice to meet you. I am Gao M. I have read your post carefully and this is very interesting for me. I have 15 years of experience in software development and have already completed 134 projects in freelancer. Especially I have much experience in MySQL, MSSQL, PostgreSQL, Oracle, SQLite and so on. If you choose me, I will give you a perfect result. I want to discuss more details. I hope to work with you. I am always ready and I will wait for you. Thanks.

I am specialize in website design and development and are excited for the opportunity to work with you in accomplishing your goals. We have developed thousands of websites in many programming languages for clients all over the world. airobos could you please inbox me more detail about this project

hi, this sql statement is not correct ,please see the correct sql statement : Select * from TestTable where data = 'test' or data = 'test1' I have experience in MS SQL server and VB.net more than 12 years. CV: I am software engineer, Holder of a degree in Faculty of Information Technology - University of Syria-Aleppo - year 2006. Programming and database specialized, expert in vb.net and SQL server with all versions, Crystal reports, also expert in iis and Windows servers 2005, 2008, 2012… Other skills: C#, Php, my sql , technical & Sage ACCPAC ERP support, SQL Replication, Excel vba and macros, Access vba, Microsoft office(Word, Excel, PowerPoint, Access). Best Regards. Khaled Alflah

Select * from TestTable where data = 'test' and data = 'test1' The SQL statement will run but no result will be returned because at a time two different value can't coexist. A 'OR' condition or "where in ('a', 'b')" should be used. Thanks, Sayan

It will return 0 row. Here are my opinions for that fixed. SELECT * FROM `TestTable` WHERE data = `test` AND data1=`test`; SELECT * FROM `TestTable` WHERE data = `test1` OR data1=`test2`; I am a senior Backend Devloper and mastered SQL queries. Please let me know your think. Regards.

Hello, sir. Much interested in your project, and I'd read all of your requirements carefully. I checked ur query. I think that ur query is wrong. correct query is "Select * from TestTable where data = 'test' and name = 'test1' ". I'm thinking this is the suitable one you're looking for. I'd like to talk with you over chat, share more details of your requirements. It will be pleasure to work with you. I hope to get a chance to do that

Proposal - You can expect anything from me on SQL. The query which you have shared never returns any result. I am guessing you want test and test1 both kind of record from your table. So the correct query will be as shown below: Select * from TestTable where data IN ( 'test', 'test1') 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 • 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;

Hi, I just reviewed your project description and interested in your project. My skills like is matched your project's requirement skills perfectly, so No problem to implement your project and sure you will get the satisfied result. Let's argue more details of the task at the freelancer's chat room. hope to see you again!. Best regards,

The query is correct about sintax, but it is not correct about logic. Why search data = 'test' AND 'test1'. I suppose that you can correct it using OR to have all records with data = 'test' or 'data = 'test1' Hi, I am an italian developer with a lot of experience on db, sql, asp.net and php. Please contact me., Angelo

Answer : No, because you have used and operator in your where clause. correct query is given below: Select * from TestTable where (data = 'test' or data = 'test1) Proposal : Dear Sir/Ma'am, I am full time experienced web developer.I have read your project details and I am ready to start work on your project and give you best results as you want. If you want to check my previous work then you can check my portfolio for your reference, I have done many project in PHP and also done Angular 4,5,6 project with back end PHP. Just message me once if you want to discuss more about project as I always be there. Waiting for your reply Thanks & Regards, Kishan Chauhan

hi I would like to work for this. ping me if you are interested Select * from TestTable where data = 'test' and data = 'test1'

There is no syntax error, but it will not give you result if only one value present in that column. So we will write below query. SELECT * FROM TestTable WHERE data IN ('test','test1') Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 9.7 years experience in MS SQL Server and 6.11 years experience in SSRS, SSIS (Import / Export). Please let me know more details and when we will start. Sky pe jikenjd

Hello, I'm 8+ years experienced DBA, I was working At TCS from 2011- 2017 as a DBA and Your query is wrong because The condition you applied status will never True. The right query is Select * from TestTable where data in( 'test' ,'test1') Contact me and share details about the project so we discuss further and my price is negotiable. Regards, Ahtsham Uddin Shaikh

Hi Below is the answer to the Query Above mention select query is not correct below is the right way select * form TestTable where (Data='Test' or Data ='Test1') Looking for positive response Thanks JJ

Well if you ask syntax wise then there is no syntax error in this query, but it will not give you any result as a column cant be equal to different string . so we should use OR in this query instead AND. so correct query should be Select * from TestTable where data = 'test' or data = 'test1'

It is not possible, it can possible if you want like data in ('test', 'test1') and you will give me chance to work with you. 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 am looking for full time or hourly  remote job.

SELECT * FROM TestTable WHERE data IN ( "test", "test1" ); ⭐ Let's discuss on chat ⭐ I 'm a Full-stack developer and Ethical hacker Working last 7 years in the programming field. I love programming. My passion is to solve the programming issue. Technology Summary :➤ ✔️Programming/Languages: PHP, Python, JavaScript, jQuery, Vue.js; ✔️Databases Management: Oracle 8.x/9.x, SQL Server, MySQL, PostgreSQL,MongoDB ,MariaDB ✔️Expert proficiency with Linux and UNIX operating systems ✔️Framework : Laravel,Django,Codeigniter ,CakePHP,Django,Wordpress ✔️Server: Ubuntu Apache, CentOS, AWS, Domain, SSL.

False! Answer: Select * from TestTable where data = 'test' OR data = 'test1' ************Responsibility + Endless Effort = YOUR Satisfaction!***************** I read your requirements carefully and I am 100% sure with 5+years experience that I can satisfy YOU with my work. Thanks for posting a project and giving me a potential opportunity to work for YOU.

Hi, I have 7+ years of experience working with top IT companies as a Database developer and designer. I have expertise in designing ER diagram according to the product requirement. I have completed multiple projects as a Database designer and I am sure that I would be able to complete your project as required with maximum efficiency. Select * from TestTable where data = 'test' and data = 'test1' - this is not possible. correct query - Select * from TestTable where data = 'test' or data = 'test1'