QUERY



IBM's flagship relational database management system

QUERY

Postby Bhanu_Praveen » Sat Jan 19, 2019 5:33 pm

Hello everyone,

I have a requirement described below.

I need to select deptno,maximum salary, minimum salary of each dept from emp table where dept contains atleast 2 employees and maximum salary in dept is > 50000.

I have attached the table data and query I have tried which is not giving any result , neither an error.
You do not have the required permissions to view the files attached to this post.
Bhanu_Praveen
 
Posts: 2
Joined: Sat Jan 19, 2019 4:53 pm
Has thanked: 0 time
Been thanked: 0 time

Re: QUERY

Postby enrico-sorichetti » Sat Jan 19, 2019 5:59 pm

if You want people pay attention to Your questions, You should learn to use better titles/subjects

subject: query
text: where is the toilet ?

the question asked fits the subject :mrgreen:
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Help needed to write an SQL query

Postby Bhanu_Praveen » Sat Jan 19, 2019 7:55 pm

Subject edited
Bhanu_Praveen
 
Posts: 2
Joined: Sat Jan 19, 2019 4:53 pm
Has thanked: 0 time
Been thanked: 0 time

Re: QUERY

Postby steve-myers » Sat Jan 19, 2019 9:59 pm

Not only that, but we primarily discuss mainframe DB2, not toy machine DB2 in this forum.
steve-myers
Global moderator
 
Posts: 2105
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 243 times

Re: QUERY

Postby NicC » Sun Jan 20, 2019 5:29 pm

Please do not post images - a simple cut and paste will do fine but ensure you use the code tags (search the forum for information on this) around your pasted data.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post