automaty do gier
skip to main
|
skip to sidebar
SQL Query by Parth Dhorda
Social Icons
Pages
Home
17. Calculate the average amount ordered.
No comments:
Post a Comment
Newer Post
Next Page
Home
Subscribe to:
Post Comments (Atom)
Popular Posts
5. List of snum of all salesmen with orders in order table without an duplicates.
14. Find out the largest orders of salesman 1002 and 1007.
2. Give all the information about all the customers with salesman number 1001.
3. Display the information in the sequence of city, sname, snum, and Commission.
18. Count the no. of salesmen currently having orders.
6. List of all orders for more than Rs. 1000.
7. List out names and cities of all salesmen in London with commission above 10%
9. List all order for more than Rs. 1000 except the orders of snum,1006 of 10/03/99
You can write the same Query in two different ways.
16. Calculate the total amount ordered.
12. List all customers whose names begins with letter 'A' to 'G'
About Me
Unknown
View my complete profile
Powered by
Blogger
.
Total Pageviews
Translate
Social Icons
Social Icons
Followers
Search This Blog
Home
Home
Blog Archive
▼
2014
(22)
▼
July
(22)
SQl Tutorial and various Quiries
See the structure of salesman table
Insert values into table salesman
As said earlier create a similar table named as Cu...
Query in our lab manual
2. Give all the information about all the customer...
3. Display the information in the sequence of city...
4. List of rating followed by the name of each ...
5. List of snum of all salesmen with orders in ord...
6. List of all orders for more than Rs. 1000.
7. List out names and cities of all salesmen in Lo...
8. List all customers excluding those with ratin...
9. List all order for more than Rs. 1000 except th...
10. List all orders taken on 10 of March,April and...
11. List all customers whose names begins with a...
12. List all customers whose names begins with let...
13. List all orders with zero or NULL amount.
14. Find out the largest orders of salesman 1002 a...
15. Count all orders of 10-Mar-99.
16. Calculate the total amount ordered.
17. Calculate the average amount ordered.
18. Count the no. of salesmen currently having or...
Blog Archive
▼
2014
(22)
▼
July
(22)
SQl Tutorial and various Quiries
See the structure of salesman table
Insert values into table salesman
As said earlier create a similar table named as Cu...
Query in our lab manual
2. Give all the information about all the customer...
3. Display the information in the sequence of city...
4. List of rating followed by the name of each ...
5. List of snum of all salesmen with orders in ord...
6. List of all orders for more than Rs. 1000.
7. List out names and cities of all salesmen in Lo...
8. List all customers excluding those with ratin...
9. List all order for more than Rs. 1000 except th...
10. List all orders taken on 10 of March,April and...
11. List all customers whose names begins with a...
12. List all customers whose names begins with let...
13. List all orders with zero or NULL amount.
14. Find out the largest orders of salesman 1002 a...
15. Count all orders of 10-Mar-99.
16. Calculate the total amount ordered.
17. Calculate the average amount ordered.
18. Count the no. of salesmen currently having or...
You can write the same Query in two different ways.
No comments:
Post a Comment