Nested Queries

3 views
Skip to first unread message

Prashant Moorthy

unread,
May 11, 2006, 5:05:33 PM5/11/06
to CMPE226_sp...@googlegroups.com
Ethan,
 
Attahced is the 4 nested queries. I got it to work after some trial and error.
 
The desc of the queries are as follows:
1)List start time and end time of the employee whose salary is greater than 80000
2) List the Position and Salary of the employee who has premium >= 15.
3) List start time and end time of the employee whose are Managers
4)Select the Position and Salary of Employees who work after 05:30 PM.
 
Please let me know if you have any questions.
 
Rgds,
prashant

 
On 5/11/06, Ogbeide Ikhile (EJ) <ej4...@yahoo.com> wrote:
Etan,

I just ran the last file ph send seems to be runing good. Can you pls try it again


Prashant Moorthy <prashant...@gmail.com> wrote:
Ethan,
 
Its a data issue as given in my previous mail. Use the database file attached in this mail. You shldn't be getting that error.
 
Rgds,
Prashant
 
On 5/11/06, Ethan <EthanL...@gmail.com > wrote:

Hi guys,

I just try to run the SQL queries on the data Prashant gave us, and now
everytime I run the query, the MLPQ will be closed automatically. I
cannot get anyresult from it. Can anyone else try it too? I want to
make sure if it only happens to me or it's the same to everyone. In the
SQL queries.zip I gave you before, there are the SQL queries files in
it. After importing the database, just click the SQL button, click any
kind of queries, and load the corresponding queries. For example, if
you click basic query, then load anyone between Basic1~Basic4.

The queries work fine in the previous data, I don't know why it doesn't
work now. Please help me test it.

Best regards
Ethan






Get amazing travel prices for air and hotel in one click on Yahoo! FareChase


Prashant Moorthy

unread,
May 11, 2006, 5:06:59 PM5/11/06
to CMPE226_sp...@googlegroups.com
Sorry.. Forgot the attachment...

PFA....
 
nested.zip

Ethan

unread,
May 11, 2006, 6:19:01 PM5/11/06
to CMPE226_spring06_sjsu
Thx Prashant,

I just wanted to post the 3 and 4, and now I see that you finished them
all. Thank you for your help.

Best regards
Ethan

Ogbeide Ikhile (EJ)

unread,
May 11, 2006, 6:21:30 PM5/11/06
to CMPE226_sp...@googlegroups.com


Prashant Moorthy <prashant...@gmail.com> wrote:
You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
class desc.doc

Prashant Moorthy

unread,
May 11, 2006, 6:34:11 PM5/11/06
to CMPE226_sp...@googlegroups.com
Guys,
Attached is the Final report for Project 2. Please review the same and send your feedback/comments by 4:00 PM.
 
Rgds,
Prashant

 
BlueSky-Project-2.doc

Prashant Moorthy

unread,
May 11, 2006, 7:10:41 PM5/11/06
to CMPE226_sp...@googlegroups.com
Somebody please respond..
 
I want to submit this before 4:30PM... Waiting for your approval...
 
Rgds,
Prashant

 
On 5/11/06, Prashant Moorthy <prashant...@gmail.com> wrote:
Reply all
Reply to author
Forward
0 new messages