Completed

SQL Query _ Compare multiple Columns

I have the following table ;

1. Main Class

2. Recommended Class # 1

3. Recommended Class # 2

4. Recommended Class # 3

5. Recommended Class # 4

6. Recommended Class # 5

The issue is that sometimes the Main class is repeated among the recommended classes. Need to make sure that there is not repetition between classes. The query needs to compare between columns so every column have unique values in the query results.

The query results look like;

1. Main Class

2. Recommended # 1

3. Recommended # 2

4. Recommended # 3

One more point. In some occasions the Recommended class is null so it will need to move the recommended class . For instance recommended class # 1 is null so recommended class # 2 will become recommended class # 1.

Skills: SQL

See more: SQL Query, multiple instance, move sql, oracle sql compare query results, sql query multiple values, query class, compare results sql oracle, compare query results oracle, sql oracle compare query results, sql query sql query, multiple table, compare time sql, compare sas sql, foxpro compare cnet sql 2005, compare php sql time, compare dbase sql, sql 2005 compare start string

About the Employer:
( 38 reviews ) Miami, United States

Project ID: #7019867

Awarded to:

NourElDeen

Dear Sir, I DID IT [login to view URL] Consider your query is done. I'm interested on doing your project. Kind Regards, NourElDeen

$30 USD in 0 days
(27 Reviews)
4.8

31 freelancers are bidding on average $30 for this job

eperfections

Dear Sir, I am highly skilled database programmer. I would like to work on this project. Please award me. Thanks

$44 USD in 1 day
(76 Reviews)
6.0
truongnguyen86

Hi there, i'm expert on SQL, let me help you with this. Which DBMS you're using to solve this. Waiting for your feedback. Thank you

$50 USD in 1 day
(82 Reviews)
5.8
pivn

A proposal has not yet been provided

$25 USD in 1 day
(7 Reviews)
4.9
Reza2012

A proposal has not yet been provided

$41 USD in 1 day
(19 Reviews)
4.4
szaszalexmcpd

Hello, I could provide the specified query relatively quickly, in TSQL (Microsoft Sql Server). Please do not accept my bid if you are looking for a solution in a different SQL variant (like MySQL, Oracle). Regard More

$15 USD in 1 day
(14 Reviews)
3.6
MSDev2012

A proposal has not yet been provided

$25 USD in 1 day
(9 Reviews)
3.6
thegrchet

A proposal has not yet been provided

$20 USD in 1 day
(1 Review)
2.3
lucasroy7

Dear, It is not complicated to do what you want. I can develop a Store Procedure without parameters which runs and fixed your table. If you agree, please contact me. Thanks!

$30 USD in 1 day
(3 Reviews)
2.1
Yknox

Hello I'm interesting your project very well I'm a Good Java, Math, Algorithm expert. I understand your req exactly. I m quite well experienced in these assignment jobs. Let's go ahead with me I want to servi More

$50 USD in 1 day
(2 Reviews)
2.0
fanninson45

I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well and within your budget. I have worked on similar projects to what you are looking for, and I am c More

$25 USD in 1 day
(1 Review)
1.0
dikgenius

A proposal has not yet been provided

$30 USD in 1 day
(1 Review)
0.8
ripasahasl

Hello Sir, I'm interested in this job. I'm available to do this task right now. Give me one opportunity to work in Your project. If possible, plz give me Your table's sql so that I can test it. Looking forward More

$30 USD in 1 day
(1 Review)
0.4
proghuman

Having 4+ years of vast experience in SQL and starter in freelancing,i can solve this in short time span. Will make sure to use the opportunity to fullest.

$10 USD in 1 day
(0 Reviews)
0.0
Neno585

Hello, I am employed a SQL Server and ASP.Net developer, so I handle and manipulate data pretty good. I could solve your issue with class repetition without much problems. If you want me to help you, feel free to conta More

$20 USD in 1 day
(0 Reviews)
0.0
amilcov

A proposal has not yet been provided

$14 USD in 1 day
(0 Reviews)
0.0
sitedataview

Hello! My name is Kimberly Killian and I am with SiteDataView. I specialize in Web and Database Solutions. I am located in Metro Detroit which is in the Eastern time Zone. I have over 20 years experience in the fie More

$111 USD in 1 day
(0 Reviews)
0.0
joykhanna

I have 2 years working experience . I already worked on such problem and i have solution. I have to module it as per your problem and perform test.

$15 USD in 1 day
(0 Reviews)
0.0
sherifyouseef97

Dear sir , I have created several systems before , I am ready to complete your application and i have strong knowledge with web development since 2007 using .net , sql and MVC ready to start working now thanks and rega More

$25 USD in 1 day
(0 Reviews)
0.0
chewightwick

Hi, I propose to create a view that uses multiple sub views. The first internal view normalises the flat table removing nulls, the second step removes the duplicate classes, the final step then flattens the normalise More

$50 USD in 1 day
(0 Reviews)
0.0
Sreenath413

I have a sound knowledge on Sql from basic to advanced Pl/Sql. I write the queries which not only works accurate but will be efficient and makes the query performance better and cost effective. Please consider the pr More

$10 USD in 1 day
(0 Reviews)
0.0