SQLBase Zone

    Database ZONE

  • SQLBase

 
Article Author
"Top 10 customers by salesperson" sound familiar? Yes! I would expect so, and am sure there are a number of other great business analyses with a similar principle now flowing through your mind.

So, how do you query this data in your SQL system?

No answer; no worries! This article aims to answer that question for you. As the title suggests, this comes down to knowing a customer's rank with respect to other customers for a given salesperson and then selecting just those customers with a rank no greater than 10.
...
Article Author

One of the regular tasks for a SQL Developer (or DBA) is to UPDATE data of existing rows, after they are in the table. A simple example, to update an existing row, based on the primary key, would look like this: UPDATE tbl_employee
SET last_name = 'whatever'
WHERE ssn = '123-456-789';Easy enough, and the same syntax works for all database engines the same.

But in this article, we will check to see what the syntax is, and what errors newcomers run into, when the data has to ...
Article Author
DATE and TIME ... don't be scared, just do it right

DATE,TIME,MS SQL Server,MySQL,Oracle



I presume you all have already worked with databases and queries, and found some difficulties to get the date/time stuff right. Though it's not rocket science, the purpose here is to teach you how to handle date and times, and to avoid implicit data type conversions.
NOTE: I refer to the versions MSSQL Server 7 through ...
Article Author
There are ONLY 3 ways to speed up MySQL, and everything else is simply a finer point of one of these 3 ways. Here they are, in order of importance:

1. Optimize queries
2. Tune the MySQL configuration
3. Add more hardware


...
 
 
Must Read
Today | All Time
View All
 
 
Zone Advisors

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

 
 
Windows 7 Release

What do you think about Windows 7? Write a review or a how-to about Microsoft's newest product and earn unlimited points!

 
 
[x]
Neglected Question
Neglected questions are any questions that either have not yet been addressed by an expert, or a solution has not been awarded, and may be eligible for bonus points (see your profile page for details).
Date Points Title Comments
1
 12/24/09 12:19 PM 500 sql query 9
2
 12/22/09 03:39 AM 500 URGENT Old Gupta Database down 5
3
 12/20/09 01:11 PM 500 RMS 11
4
 12/10/09 01:20 PM 500 removing duplicate rows 3
5
 12/10/09 01:11 PM 500 Building a database application in Android.  Beginner here. 1
6
 12/09/09 06:53 AM 100 MS Access Update Query "multiple matches" need to use the oldest match. 1
7
 12/04/09 02:49 PM 500 MySQL procedure on SQL 10
8
 12/02/09 01:48 PM 500 sql condition to extract data from database 2
9
 11/29/09 11:05 AM 500 update query required. 3
10
 11/27/09 11:14 AM 500 hot to create foreign key values but without create the value table? 5
View More Questions Awaiting Answers
 
 
 
Loading Advertisement...
ADVERTISEMENT