[Show all top banners]

redlotus
Replies to this thread:

More by redlotus
What people are reading
Subscribers
Subscribers
[Total Subscribers 1]

Rolemodel
:: Subscribe
Back to: Kurakani General Refresh page to view new replies
 help on SQL
[VIEWED 3568 TIMES]
SAVE! for ease of future access.
Posted on 03-26-09 4:16 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 



11. Write a query that produces the following for each employee:



<employee last name> earns <salary> monthly but wants <3
times salary>. Label the column Dream
Salaries
.




 



12. Display the last name, hire date, and day of the week on which the
employee started. Label the column DAY. Order the results by the day of the
week starting with Monday.




5.  Write a query to display the department name,
location name, number of employees, and the average salary for all employees in
that department.  Label the columns
dname, loc, Number of People, and Salary, respectively.  Round the average salary to two decimal
places.  Match on deptno between the EMP
and DEPT tables


 
Posted on 03-26-09 4:27 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

redlotus, while you are at it, why don't I also help you with your laundry, cooking, washing and taking your girlfriend on a date. Imbecile you are of Biblical proportion. Disgusting lazy sheep, tame you, I will.



 
Posted on 03-26-09 4:33 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

JG if you donot want to answer thats fine. I have suggestion for u, mr active. donot waste your time reading my post.

 
Posted on 03-26-09 4:40 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

did u try www.w3schools.com. It should be helpful
 
Posted on 03-26-09 9:41 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Where r the tables?


 
Posted on 03-26-09 9:43 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Ya I was wondering too where is the table structure?


bhaai ke chha? long time no talk........


 
Posted on 03-26-09 9:47 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

dijju kata gayap hajur?

 
Posted on 03-26-09 9:53 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

redlotus:


Can you publish which school you go to along with your lecture's contact details?


 
Posted on 03-26-09 9:58 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Where are the Tables and column names there in?


YEAH!





 


 


 


Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 7 days
Recommended Popular Threads Controvertial Threads
TPS Re-registration case still pending ..
To Sajha admin
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters