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 7625Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
5 13770Could 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 3711Below 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 3044Post New HSBC Interview Questions
Is hibernate better than jdbc?
What is the disease caused by influenza a subtype h5n1?
What is step up cyclo-converter ?
Can partial class be inherited?
What do you know about Banking Laws?
What does appdelegate swift do?
Explain what are the events recorded in a transaction log?
Is the primary key an index?
What is the difference between jquery's ready and holdready?
We have purchased some good from our vendor and we asked them to transport the same to some address but they have raised a debit note to us for transportation instead of invoice. Same like we have given some order to manufacture for developing that product they have charged some amount for that also they have raised the debit note. How to account these type of debit notes in tally..?
Should services be stateless?
How can you check whether a record is valid record or Invalid record using ADO control or Object?
How do you combine two lines from two sorted files in linux?
Mention what is the unit to measure x-rays exposure?
What are the extension methods in c#?