I want to retrieve the first record of each dept ID, Please help me design an SQL query for this
Example table is :
Employee Name Dpet ID
John 1800
Rex 1900
Robert 1800
Jeana 2000
Cami 1900
Praveen 2000
Bhanu 1900
My SQL should return the following:
John 1800
Rex 1900
Jeanna 2000
SQL query to retrieve one record for each Plan from a DB2 Ta
Previous topic • Next topic • 1 post
• Page 1 of 1
SQL query to retrieve one record for each Plan from a DB2 Ta
by naren_tanneru » Wed Sep 10, 2014 12:55 am
- naren_tanneru
- Posts: 1
- Joined: Tue Sep 09, 2014 11:58 pm
- Has thanked: 0 time
- Been thanked: 0 time
Previous topic • Next topic • 1 post
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- DB2 Replace Query retrieve junk character
by trilochan_p » Mon Apr 14, 2014 11:20 pm - 8 Replies
- 6568 Views
- Last post by trilochan_p
Tue Apr 15, 2014 9:03 pm
- DB2 Replace Query retrieve junk character
-
- Query to get table record count inDB2 schema
by ritikasingh » Thu Jul 14, 2011 8:06 pm - 3 Replies
- 8017 Views
- Last post by GuyC
Fri Jul 15, 2011 5:06 pm
- Query to get table record count inDB2 schema
-
- plan and package
by nithyanandhan » Sat Aug 21, 2010 10:04 pm - 1 Replies
- 3088 Views
- Last post by dick scherrer
Sat Aug 21, 2010 11:36 pm
- plan and package
-
- Plan and Package for New DB2
by jaggz » Fri Jun 17, 2011 10:33 am - 6 Replies
- 4270 Views
- Last post by GuyC
Wed Jun 22, 2011 8:56 pm
- Plan and Package for New DB2
-
- Packages under a plan
by ravi11081992 » Mon Jan 14, 2019 9:15 pm - 1 Replies
- 1825 Views
- Last post by NicC
Mon Jan 14, 2019 10:13 pm
- Packages under a plan