how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900
8 9754Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)
6 15001Can i possible to see Table Details ? Ex : Table Name Date Time User Emp May/18/2010 12:59pm Scott
3 6419Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d
4 8511how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing
1 4143
discuss about myisam index statistics collection. : Sql dba
Show code of a cursor for loop.
What is the difference between python and sql?
What does fetching a cursor do?
What are stored procedures used for?
Explain the structure of pl/sql in brief.
What is the clause we need to add in function body to return variable?
What does select * from mean in sql?
Is join an inner join?
How do I create a sql database?
What is query execution plan in sql?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
How do we accept inputs from user during runtime?
What is auto increment feature in sql?
Can we rollback truncate?