December 12, 2013 at 10:51 am
hi, experts....
i had 1000 employees... each employee i paid every month salary.i.e.03/13 ,04/13....Each employee have some employee id .i.e.unique number..
I want to retrieve the particular employee id and every month salary details in monthly wise.
December 12, 2013 at 11:23 am
Good luck with your homework.
To get some help, feel free to read the article linked on my signature.
December 13, 2013 at 3:59 am
So what you're looking for is a SELECT statement. You'll need to especially focus on the column list and the WHERE clause. Read all about it here. If you are stuck on a particular aspect of it, let me know.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 13, 2013 at 7:07 pm
kanala.madhu (12/12/2013)
hi, experts....i had 1000 employees... each employee i paid every month salary.i.e.03/13 ,04/13....Each employee have some employee id .i.e.unique number..
I want to retrieve the particular employee id and every month salary details in monthly wise.
This may well be homework as has been suggested but even if it isn't you've worded your question in a way that says do my work for me.
Always a good idea to post what you've tried and of course ddl, sample data and expected results.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply