Solved

Need a handful or practice queries for an upcoming live test

Posted on 2008-09-29
2
250 Views
Last Modified: 2013-12-07
I'm  studying  for a live test in  which I'll be put in front of  a  computer and given queries to write.  This is not for a DBA position, it's a C# developer's role.

What kinds of questions would you pose?

I'd love to see them and see how many I could write without getting stumped.  I expect at least a few joins, and imagine at least one where the query is embedded in another querie.  (What's that  called?)



thnks  for  the help,
newbieweb
0
Comment
Question by:newbieweb
2 Comments
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 250 total points
ID: 22602504
0
 
LVL 1

Assisted Solution

by:Digitasupport
Digitasupport earned 250 total points
ID: 22604735
What you are referring to is called a 'Nested query'
A query within a query
You need to look at possibly the following query methods:-
Simple selects
Joins (Left , right , inner , outer , Union)
Nested queries.
Updates , Inserts , Deletes , maybe you need to know how to updtae system catalogues as well.
As mentioned above , W3schoools is good , but the beolw i feel is more relavant to you:-
http://msdn.microsoft.com/en-us/library/ms189826.aspx
This is where i would start to research certain query methods , as this will go by the 'Microsoft grian'
Hope that helps you:)
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question