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 7678Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
5 13897Could 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 3741Below 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 3084Post New HSBC Interview Questions
Is static a keyword in java?
Mention in brief, what is the role of scrum master in scrum?
What is isr? Can they be passed any parameter and can they return a value?
What is your approach when requirements change continuously?
Explain waterfall model? what will the testing team do in Requirement phase in this model and what happens in design phase?
What is Big Data?
what kind of a manager would you be?
Explain error and transaction handling in sql server?
What is a jdbc url?
Which command is used to replace CDUP command in FTP IF i WANT TO USE SFTP?
What are the windows os versions?
What is the administrator workbench in R12?
How to send 10,000 mail?
If i have a company in India doing purchase from Shrilanka, If i buy in Shrilankan local currency and make the payments in Indian Currency At the end of year how shall i settle the difference Exchange money in Books of Accounts.
Is integer passed by reference in java?