Find Jobs
Hire Freelancers

need a sql table with joins and query to be answered - open to bidding

$10-30 USD

Geschlossen
Veröffentlicht vor mehr als 10 Jahren

$10-30 USD

Bezahlt bei Lieferung
1. Select all columns, without explicitly naming them, and all rows from one table [login to view URL] 5 columns and 10 rows (use ROWNUM) from one table. Use ORDER BY to sort the results. [login to view URL] DISTINCT in a SELECT on one table that produces unique records in such a way so that the rows returned are less than the row count of the table (without use of ROWNUM) [login to view URL] WHERE to join 3 tables; select all columns, without explicitly naming them, and all rows. Use table aliases to identify the source table. 5. Use JOIN to select 5 columns and 10 rows (use ROWNUM) from two tables. Use table aliases to identify the source table. Use a WHERE clause that uses the "LIKE" special [login to view URL] a SELECT statement that uses SUM and GROUP BY [login to view URL] a SELECT statement that joins 2 tables (use WHERE) and IN [login to view URL] a SELECT statement that determines the LENGTH of a VARCHAR2 variable data column in one table [login to view URL] a SELECT statement that uses AVG. Use a column alias for at least two column headings [login to view URL] a SELECT statement that uses MIN and/or MAX [login to view URL] a SELECT statement that joins two or more tables. SELECT several columns from each table. Concatenate two or more columns to form a single column. 12. Create a SELECT statement that compares a column of type "DATE" with SYSDATE or that compares two date fields. [login to view URL] UPDATE to alter a single row in one table (use WHERE) [login to view URL] UPDATE to alter multiple rows in one table using a subquery [login to view URL] DELETE to delete a single row in one table (use WHERE) [login to view URL] a SELECT statement with a subquery in the WHERE clause [login to view URL] a SELECT statement with a subquery in the HAVING clause [login to view URL] a SELECT statement using a correlated subquery using a WHERE condition or WHERE EXISTS [login to view URL] a left outer join on two tables (explain results) [login to view URL] right outer join on two tables (at least one table different than 19; explain results) Note: You should ha
Projekt-ID: 5215466

Über das Projekt

24 Vorschläge
Remote Projekt
Aktiv vor 10 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
24 Freelancer bieten im Durchschnitt $36 USD für diesen Auftrag
Avatar des Nutzers
• Over 15 years’ experience as Software Developer using almost all Microsoft technologies. • 12 years' experience with SQL Server including last version SS2012. • 4 years as Technical Leader. • 2 years of international experience. • Strong analytical, object-oriented programming, database design and data modeling skills. • 10 years experience as freelancer, specially on freelancer.com or rentacoder.com.
$170 USD in 3 Tagen
5,0 (82 Bewertungen)
5,3
5,3
Avatar des Nutzers
Hi I'm very interested helping you on your sql queries, I have more then 7 years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some samples of databases modeling and database administration manual. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please send me all other details about your queries, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$64 USD in 3 Tagen
5,0 (24 Bewertungen)
4,9
4,9
Avatar des Nutzers
Hi, First of all thanks for posting such a project. I am oracle certified developer and dba with more than 5 years of experience. I am expert in SQL, PL/SQL. I did lots of oracle project in freelancer. http://www.freelancer.com/u/nibiranijum.html I am confident on delivering quality. If you wish, I can show you my existing projects. Rgds, Shafiq
$40 USD in 3 Tagen
4,9 (13 Bewertungen)
4,8
4,8
Avatar des Nutzers
Hi I can Create the scripts for you. About me : I am a software / SQL developer with 3+ years of experience. I'll give you the scripts in next 1 hour Await your reply,.
$30 USD in 3 Tagen
5,0 (1 Bewertung)
4,4
4,4
Avatar des Nutzers
Hi! I am expert in SQL queries and can do this for you see my reviews for more confirmation and contact me if interested..Thanks!
$40 USD in 3 Tagen
4,5 (4 Bewertungen)
3,6
3,6
Avatar des Nutzers
Hi This is bhargava . I am expert in sql and Pl/sql . I have done so many sql projects and assignments successfully . I am ready to complete your task on time .
$25 USD in 0 Tag
4,7 (14 Bewertungen)
3,4
3,4
Avatar des Nutzers
hi there lets we do it, i hope to have talks with you on this project, i am sure i can make this for you, regards sigmason
$29 USD in 1 Tag
5,0 (11 Bewertungen)
3,2
3,2
Avatar des Nutzers
A proposal has not yet been provided
$10 USD in 1 Tag
5,0 (4 Bewertungen)
2,5
2,5
Avatar des Nutzers
I have done work in SQL and used many different database systems. I can do work on your this project. Conisder me for your this project. I will be waiting for your reply.....
$40 USD in 2 Tagen
5,0 (3 Bewertungen)
2,0
2,0
Avatar des Nutzers
Dear Shisen, We've 10 years of experience in field of excel,VBA, VB,.Net programming,access,Sql express. We did data importing work in many projects so as to accomplish new project without interrupting the clients day to day activity. Please give us a chance to fulfill your requirements. With best regards, Sasi, PNR Freelancer
$20 USD in 1 Tag
5,0 (3 Bewertungen)
1,5
1,5
Avatar des Nutzers
Greetings! I've gone through your project details. It's just some queries to be written. I can complete this task quite efficiently. Thanks. Hope you'll contact me regarding this task.
$30 USD in 1 Tag
5,0 (1 Bewertung)
1,1
1,1
Avatar des Nutzers
Hi, We are new here but not new in development We are a Web Design & Development Company, leading SEO with over 8 years of experience. We have been partnering with various digital agencies over U.S., UK, Australia, Canada & Europe. We have done similar task by a number of times and we can do this for you too please discuss to start. By full time dedicated work we will complete this project on time and will produce a level best reliable solution with free six month support. We offer following Services with affordable cost than what it might be in house: - 1. E commerce Application Development 2. Payment gateway integration 3. Website Development. 4. CMS [drupal/wordpress/joomla ] based development 5. Website Designing. 6. Flayer / Logo / Visiting cards design 7. Link Building. 8. SEO (search engine optimization) with full plan & packages. 9. SMO (Face book, Twitter, LinkedIn, YouTube, MySpace Marketing etc) 10. Technical Content Writing Please discuss Thanks & Regards, -------------------------------- Marry S.
$35 USD in 0 Tag
5,0 (1 Bewertung)
0,9
0,9
Avatar des Nutzers
Hello, I can provide instant answers to your 20 sql questions. let me know if do you want me to help. Thanks, George
$40 USD in 0 Tag
5,0 (1 Bewertung)
0,0
0,0
Avatar des Nutzers
Hi. I am a new freelancer and I have very strong skills in Database development. Currently working as DB developer in a very large organization in Australia. I will do a good job if you can give me this peace of work. I am more interested in feedback than the money
$30 USD in 3 Tagen
5,0 (1 Bewertung)
0,0
0,0
Avatar des Nutzers
I m a PHP developer. I have 5+ years experience in PHP, Wordpress, Joomla, Magento, Prestashop, CSS, JQuery, HTML etc. I also developed many software applications for banking, accounting, code generator, printing bills etc. I mostly like to designing the websites. Also have ability to modify any pluggins, templates, theams, database etc. Waiting for your positive response. Thank You
$30 USD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
A proposal has not yet been provided
$25 USD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
I am working In Oracle Argentina. I can do this job without difficulties. Regards and thanks! Laura.
$25 USD in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
I am an Oracle Database SQL Certified Expert, and have done very complex query works with SQL Server, and found your Project interesting. It can only take me maximum of 3-days to finish your project, if given the opportunity.
$25 USD in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
A proposal has not yet been provided
$25 USD in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Aucune proposition n'a encore été fournie.
$35 USD in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von INDIA
Calcutta, India
4,6
121
Zahlungsmethode verifiziert
Mitglied seit Jan. 29, 2011

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.