I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?
2 7593Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
5 13707Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
1 3685Below is the table. Required to be output should be the highest number of each student_id. Example. Student_id Subject Marks 1 Hindi 86 2 Hindi 70 3 English 80 . Calculate sum and average marks for each group of student_id Example. Student_id Subject Marks Total Marks Average 1 English 40 181 60.33333 2 English 67 196 65.33333 3 English 80 160 53.33333 PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS
1 3021Post New HSBC Interview Questions
What amount does mechanical mechanization cost?
What are filegroups in sql server?
How often were you absent from work in your last job? Have you every had any serious illness or injuries? Do you have any health problems? : insurance sales
Can you discuss the diagnostic criteria and treatment approaches for patients with ankylosing spondylitis?
What is navigate to new proposal action?
Your team is picking reasonable action items but is later not delivering on them. How do you handle this?
What is jdbc connection?
What is referred to the electron in the outer orbit?
Can I do insert … select * into a partitioned table?
What is the Full form of IMPS and what are the features and benefits?
What is an assembly and its use?
Is it true that wireless networking is only good for laptop computer?
Why do I need a user id during configuration?
How do I update microsoft word 2007?
what is the differences between DTD's and XML schema?