Make Comments..!!
Joydip Panchal
#SQL
#GROUp BY CLAUSE
#Example
How to get max salary in each department?
Table :
id salary fname department
1 10000 prakash IT
2 12000 Ramesh IT
3 15000 Manish SYSTEM
4 7000 Suresh DEVELOPMENT
5 7500 Mukesh DEVELOPMENT
6 9500 Kamlesh SUPPORT
8 6000 Lalit SUPPORT
9 9000 Umesh IT
10 8000 Tapan SYSTEM
11 9000 Ila DEVELOPMENT
12 4500 Patan SYSTEM
13 18000 Yugank SUPPORT
Query :
SELECT MAX(salary) AS salary,department FROM table1 GROUP BY department
Result :
salary department
9000 DEVELOPMENT
12000 IT
18000 SUPPORT
15000 SYSTEM
Now if we want to display fname,id of that record, we simply add those columns name to query like :
Query :
SELECT id,fname,MAX(salary) AS salary,department FROM table1 GROUP BY department
Result :
id fname salary department
4 Suresh 9000 DEVELOPMENT
1 prakash 12000 IT
6 Kamlesh 18000 SUPPORT
3 Manish 15000 SYSTEM
Result data is contain wrong fname and id. Becase group by always fetch first row of group. So, we have to include join in to our query.
Query :
SELECT t1.* FROM table1 t1 INNER JOIN (SELECT MAX(salary) AS s,department FROM table1 GROUP BY department) AS t2 ON t2.s = t1.salary WHERE t1.department = t2.department
Result :
id fname salary department
2 Ramesh 12000 IT
3 Manish 15000 SYSTEM
11 Ila 9000 DEVELOPMENT
13 Yugank 18000 SUPPORT
#GROUp BY CLAUSE
#Example
How to get max salary in each department?
Table :
id salary fname department
1 10000 prakash IT
2 12000 Ramesh IT
3 15000 Manish SYSTEM
4 7000 Suresh DEVELOPMENT
5 7500 Mukesh DEVELOPMENT
6 9500 Kamlesh SUPPORT
8 6000 Lalit SUPPORT
9 9000 Umesh IT
10 8000 Tapan SYSTEM
11 9000 Ila DEVELOPMENT
12 4500 Patan SYSTEM
13 18000 Yugank SUPPORT
Query :
SELECT MAX(salary) AS salary,department FROM table1 GROUP BY department
Result :
salary department
9000 DEVELOPMENT
12000 IT
18000 SUPPORT
15000 SYSTEM
Now if we want to display fname,id of that record, we simply add those columns name to query like :
Query :
SELECT id,fname,MAX(salary) AS salary,department FROM table1 GROUP BY department
Result :
id fname salary department
4 Suresh 9000 DEVELOPMENT
1 prakash 12000 IT
6 Kamlesh 18000 SUPPORT
3 Manish 15000 SYSTEM
Result data is contain wrong fname and id. Becase group by always fetch first row of group. So, we have to include join in to our query.
Query :
SELECT t1.* FROM table1 t1 INNER JOIN (SELECT MAX(salary) AS s,department FROM table1 GROUP BY department) AS t2 ON t2.s = t1.salary WHERE t1.department = t2.department
Result :
id fname salary department
2 Ramesh 12000 IT
3 Manish 15000 SYSTEM
11 Ila 9000 DEVELOPMENT
13 Yugank 18000 SUPPORT
Sydney Munyaradzi
http://pcsx2.net/download.htmlll PLAYSTATION 2 games using a PLAYSTATION 2 Emulator......
http://pcsx2.net/download.html
http://pcsx2.net/download.html
Ansari Tahir likes this
Joydip Panchal
https://addons.mozilla.org/en-US/firefox/addon/wmlbrowser/
Do you want to test your WML Program files??
Just install WMLbrowser add-ons in firefox.. and you can test it into firefox...
Enjoy..
Do you want to test your WML Program files??
Just install WMLbrowser add-ons in firefox.. and you can test it into firefox...
Enjoy..
Shaily Shah and 2 other like this
Mahesh Baria
In C pls tell me answer......
main()
{
float f=1.3;
if(f==1.3)
{
printf("true";
}else
{
printf("flasle";
}
}
main()
{
float f=1.3;
if(f==1.3)
{
printf("true";
}else
{
printf("flasle";
}
}
Satyam Pandey and Mahesh Baria like this
Rakesh Pathak
false because you are compariongfloat value with double,use 1.3f in place of 1.3 , ans will true.
Like · 1 ·
Hiren Solanki
Facebook-Datalogix deal may violate privacy promises
Privacy groups say Facebook may be pushing the boundaries of its recent agreement with the FTC over how it handles user data
Privacy groups say Facebook may be pushing the boundaries of its recent agreement with the FTC over how it handles user data
Joydip Panchal likes this
Hiren Solanki
Cyber criminals hack Adobe certificate server
Adobe is working on revoking a certificate and enlisting the help of security vendors
Adobe is working on revoking a certificate and enlisting the help of security vendors
Joydip Panchal and Arpan Patel like this
Hiren Solanki
The BlueStacks App Player will allow users to run Android apps on their AMD-powered Windows PCs, including those running Windows 8.
Joydip Panchal likes this
Hiren Solanki
The apple effect on your pc be surprised if your next PC is (also) a tablet.
for more information
http://news.cnet.com/8301-13579_3-57508831-37/the-apple-effect-on-your-next-pc/
for more information
http://news.cnet.com/8301-13579_3-57508831-37/the-apple-effect-on-your-next-pc/
Admin and 4 other like this
Ansari Md Tahir