Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smallvillerules
Starting Member
1 Post |
 Posted - 2011-03-29 : 10:19:46
|
| 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? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
Help WIth Basics of SQL