automaty do gier
skip to main
|
skip to sidebar
SQL Query by Parth Dhorda
Social Icons
Pages
Home
3. Display the information in the sequence of city, sname, snum, and Commission.
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.
3. Display the information in the sequence of city, sname, snum, and Commission.
2. Give all the information about all the customers with salesman number 1001.
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%
18. Count the no. of salesmen currently having orders.
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.
Insert values into table salesman
There are two ways in which we can insert the values in any table. INSERT INTO SALESMAN VALUES(1001,'PIYUSH','LONDON',.12...
8. List all customers excluding those with rating <= 100 or they are located in Rome.
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