Search the Community
Showing results for tags 'sql query'.
-
Sql Query: I need to compare data for 2 dates while using GROUP BY <InvDate> results in multiple rows like Row1 - InvDate1 | Sum(Data Col1) | Row2 - InvDate2 | Sum(Data Col1) | But I need like Row1 - Sum(Data Col1) for InvDate1 | Sum(Data Col1) for InvDate2 Kindly help resolving it! Thanks! Jenender
-
Hi, Need help in code trying to find employees old positon number but the job table gives current row position number since the employee was rehired. Please help.
-
PLEASE HELP IN A QUERY. i AM TRYING TO DO SELF JOIN WITH A QUERY WHICH 2 OR MOR ELEFT OUTER JOINS IN IT. HOW TO DO SELF JOIN HERE . THANKS IN ADVANCE.
-
RcptNo Discoount ProductCode Price 111 10 1122 1000 111 10 1123 1500 111 10 1124 2000 123 20 1123 2000 124 30 1125 1000 124 30 1120 2000 I want This Result Rcpt No:111 Discount :10 TOT price :1000+1500+2000-10=------; By Which Query This Result can be Obtained
-
Hi I've been looking at the tutorial and spoken to a few people regarding a query which requires me to join two tables together and data within a specific data range. The environment I am running this in is SQL Server 2005. The following is the query I have tried to run: select *from individual (this is a table name)where update_timestamp <= 31/12/2008join delegate (this is a table name)as on member.member_ref=delegate.member_Refwhere start_date >= 31/12/2008 but when I run this, I get:Msg 156, Level 15, State 1, Line 4Incorrect syntax near the keyword 'join'. Someone advised me