Need Some Help with Basics

Question

Post reply

Need Some Help with Basics

smallvillerules

Newbie

Points: 3
More actions
March 29, 2011 at 8:23 am

#389162

Hey I'm trying to get a working understanding of some of the basics behind SQL, I've composed a few questions that I think may help me with this. Anyone that can help me with any of them will greatly help me thanks.
1. How to create synonym for tables?
2. How to describe the structure of tables?
3. How to list the contents of tables?
4. How to create a table named with the same structure as another table?
5. How to copy rows with less than a certain criteria in value (e.g. Price<$5.00) into another table?
6. How to change the data type to e.g. NUMBER(6)?
7. How to add a new column named with data type e.g. VARCHAR2(10)?
8. How to change a specific field within a table (e.g. For ORDER_NUMBER 12489, change the C_NUMBER to 315)?
9. How to delete a specific row from a table?
10. How to declare a column as the primary key of a table and call it e.g. PK_something?
11. How to show certain columns when another column is less than a certain criteria in value (e.g. Price<$5.00)?
12. How to show certain columns with another column having a certain item class e.g. HW or AP?
13. How to list certain columns when another column e.g. price is between two values?
14. How to list certain columns when another column e.g. price is negative?
15. How to use the IN operator to find certain columns (e.g. first and last name of customers who are serviced by a certain ID)
16. How to find certain columns when one of the columns begins with a particular letter (e.g. A)
18. How to list the contents of the a table sorted in ascending order of item class and, within each item class, sorted in descending order of e.g. price?
19. How to do a count of column in a table?
20. How to sum a column and make rename is something?
21. How to do a count of a column in a table (without repeats e.g. if a certain number repeats more than once than to only count it once)?
22. How to use a subquery to find certain fields in columns when the another column’s fields values are greater than e.g. its average price?

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

Have you had a look at Books online ?

most of the info should be in there

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

We're not doing your homework, exam or interview for you.

Do the work yourself.

LutzM SSC Guru Points: 107049 More actions · Answer 3

20. How to sum a column and make rename is something?

Please ask your tutor to rephrase this question. It will make it easier for you to google for an answer...

[SET RANT ON]

... (I better don't even start...)

[SET RANT OFF]

Edit: You also might ask for clarification what RDMS this class is about...

Otherwise either the answers from this site or from your "twin post" over at forums.oracle.com might be wrong...

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

LutzM (3/29/2011)
20. How to sum a column and make rename is something?
Please ask your tutor to rephrase this question. It will make it easier for you to google for an answer...
[SET RANT ON]
... (I better don't even start...)
[SET RANT OFF]

No please, it could be funny to read! :w00t:

LutzM SSC Guru Points: 107049 More actions · Answer 5

Ninja's_RGR'us (3/29/2011)
LutzM (3/29/2011)
20. How to sum a column and make rename is something?
Please ask your tutor to rephrase this question. It will make it easier for you to google for an answer...
[SET RANT ON]
... (I better don't even start...)
[SET RANT OFF]
No please, it could be funny to read! :w00t:

I know I have to practice my written English... But I don't want to use this specific thread... 😉

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

WayneS SSC Guru Points: 95460 More actions · Answer 6

LutzM (3/29/2011)
I know I have to practice my written English... But I don't want to use this specific thread... 😉

Well, you can always use The other Thread. 😀

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

terrykzncs Ten Centuries Points: 1324 More actions · Answer 7

3. How to list the contents of tables?
9. How to delete a specific row from a table?

How much of SQL do you know? Have you studied SQL before? Anything with SQL?

This is really basic stuff thats available online or in any book at the lbrary.

Then again have you used SQL before?

Richard Warr SSCertifiable Points: 6966 More actions · Answer 8

LutzM (3/29/2011)

Edit: You also might ask for clarification what RDMS this class is about...

Question 7 gives it away, and it ain't this one;-)

I see you spotted the "twin post" as well.

steveb. SSC-Forever Points: 46733 More actions · Answer 9

I don't really see the point in digging up a topic from a week ago to repeat the points already made, you need to give the guy a break..

Richard Warr SSCertifiable Points: 6966 More actions · Answer 10

Sorry - I hadn't noticed the original date. But this is clearly an Oracle query and pointing the guy to BOL is really no help at all.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 11

Ninja's_RGR'us

SSC Guru

Points: 294069

April 5, 2011 at 9:48 am

#1307554

Then perharps newb ol?

:w00t: