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 7572Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
5 13680Could 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 3680Below 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 3012Post New HSBC Interview Questions
Can group functions be mixed with non-group selection fields?
How to apply validation on props in reactjs? Apply validation in previously developed example in above question?
How to create a swing gui in java?
Can you define set to be cardinality?
What is bind variable in oracle 11g?
Explain transparent caching with aop?
Explain the monkey testing?
What is the prerequisite for doing the currency conversion?
What is hidden control in html?
How long it will take to learn c++?
Explain what are the techniques that help build the trust of the caller? : insurance cold calling
How to send a object and its value to the garbage collection?
Can you change a Master Page dynamically at runtime?
Explain how barcode create in the report?
What is dipole?