New to SQL. Could you show me a SQL query?

Hi,

i'm starting to learn Oracle SQL and the book I have wants me to write a query that selects conditions using logical OR. It must also use a calculated field.

If you can give an example of one, I'll help you out in some way in return

Thanks.

 

http://www.w3schools.com/SQl/default.asp

Eat your heart out. xD

 

 $query ="SELECT * FROM cars where id = $id";
 $result = mysql_query($query,$db) or die("GTFO my server noob");
 $myrow = mysql_fetch_array($result);

Code (markup):

 

read:

Select * from <table name>

Write

Insert into <table_names> values (<values..>)

 

Join the Online Oracle Developer Community: "OraclePassport"

Good Tutorials and FAQs for beginners and Professionals.

OraclePassport Website, Forums and Wiki contains lot of information like:

Oracle Tutorials
Oracle Discussions
Oracle Wiki
Oracle Forums
Oracle Interview Tips
Oracle Objects
Oracle Features
Data Loaders


Sippsin,
Senior Oracle Developer | Technical Writer
Oracle Tutorials, FAQ and Discussions Board

 

Select * From testtable where ID=1 OR ID=10 OR Name='YourName'

 

Check out these sql code samples and I am sure you will be able to find all the samples you could ever need.

 

SELECT * FROM Contacts WHERE Name='Bob' AND State='TX'

 

This doesn't really answer your request, but I recommend sqlzoo dot net (sorry minimum post requirement bs) in addition to your course. They have some nice exercises to help you get a bit of extra practice.

 

Defiantly this site is excellent the exercises are completely interactive