Закрыт

Need a SQL developer

Need a SQL developer to design a backend structure of a big website.

Please reply with this Query

Select * from TestTable where data = 'test' and data = 'test1' - is this possible or not ? if not whats the correct query for this,

More details will be shared with successful candidates.

Thanks,

Квалификация: SQL, MySQL, PHP, Управление базами данных, Программирование баз данных

О работодателе:
( 4 отзыв(-а, -ов) ) New Delhi, India

ID проекта: #20733178

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

omsoftware

Hello, Select * from TestTable where data = 'test' and data = 'test1' - is this possible or not ? =>Yes, this is possible and will explain you how. Work portfolio [login to view URL] Availability- 40 hrs/ Больше

₹100000 INR за 30 дней(-я)
(138 отзывов(-а))
8.9
Shattenjagger

Hello. It really depends on dialect, but for most of dialects following will be working: Select * from TestTable where data in ('test' , 'test1') That's of course if you want this query makes sense, but so far there is Больше

₹112500 INR за 7 дней(-я)
(67 отзывов(-а))
6.7
leemilun

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

₹150000 INR за 20 дней(-я)
(60 отзывов(-а))
6.4
pvsysgroupinc

Dear Sir, As per your requirement we will make your website best and also we will support after work is live as well please allow us to share our services to you hope you will be happy and we will have long term busi Больше

₹95000 INR за 30 дней(-я)
(27 отзывов(-а))
6.4
anshulikabansal

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

₹90000 INR за 30 дней(-я)
(83 отзывов(-а))
5.9
MrtDolphin

Select * from TestTable where data = 'test' and data = 'test1'. it is not correct. Please contact me. thanks in advance.

₹112500 INR за 7 дней(-я)
(17 отзывов(-а))
6.0
ArkssTech

Hello Manager Hope things are going well in your life!!   We are a team of 30+ individuals highly experienced in creating wonderful Web applications and apps for our clients to increase their business and to help them Больше

₹103631 INR за 7 дней(-я)
(40 отзывов(-а))
6.0
coolmob0816

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

₹112500 INR за 7 дней(-я)
(18 отзывов(-а))
5.3
ancineha

Hello Mate, Greeting of the day! Thank's for providing us an opportunity to bid on your project.I've gone through your job post very well and As a Highly Skilled Web Developer, I Guarantee you to serve with admirabl Больше

₹150000 INR за 45 дней(-я)
(9 отзывов(-а))
5.5
codescape2015

Hello, I have gone through the post and yes. I will help you for sure with requirement I can provide you the high quality website solutions so just let me know the features, functionalities and I can sort it for you Больше

₹75000 INR за 2 дней(-я)
(49 отзывов(-а))
5.3
esolzpk

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

₹124875 INR за 7 дней(-я)
(16 отзывов(-а))
5.4
hengzhulu

Hi sir "Select * from TestTable where data = 'test' and data = 'test1' " is wrong. "Select * from TestTable where data = 'test' or data = 'test1'" is right. I am SUPER DBA. If you hire me i will provide you perfect res Больше

₹80000 INR за 5 дней(-я)
(7 отзывов(-а))
4.6
paulprabhakarand

Hi, This is Paul Devanesan has done [login to view URL] and [login to view URL] from IIT Madras and was working for some of the famous software companies like Cognizant, Syntel, Vistusa, American Express (US) and then I started working as an in Больше

₹112500 INR за 30 дней(-я)
(24 отзывов(-а))
4.8
AISense

EXPERT bid. no bug, logic error. EXPERT bid. 1. Recently overview - NLP and DB project (10 million business real time search service) - Python SQL Project (1 billion rows / day, Data Cleansing / Migration / Integrat Больше

₹150000 INR за 15 дней(-я)
(3 отзывов(-а))
4.4
star314

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

₹100000 INR за 5 дней(-я)
(12 отзывов(-а))
4.5
angnut

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

₹112500 INR за 7 дней(-я)
(19 отзывов(-а))
4.5
vw7590795vw

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

₹125000 INR за 1 день
(23 отзывов(-а))
4.1
sreenivas2903

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

₹112500 INR за 7 дней(-я)
(15 отзывов(-а))
4.3
taijin95

Dear sir! Your Sql is no bug with syntax, but there is big bug logically. That sql will be return empty, because Where clause is contradict.. I think that what you want to get sql is following: Select * from TestTable Больше

₹112500 INR за 7 дней(-я)
(8 отзывов(-а))
4.3
shiyusun180409

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

₹80000 INR за 7 дней(-я)
(14 отзывов(-а))
4.1