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 7577Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
5 13685Could 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 3013Post New HSBC Interview Questions
what is crocodile marketing?
What is a covered index?
In many arthropods, the segments of the body are grouped into 3 distinct parts. Name all three parts?
define prolog tab?
How r handles missing values?
What is natural language understanding (nlu)?
What are the types of database management system?
What are the technologies used by ajax?
How do I open an excel file?
What is the difference between ISBLANK() AND ISNULL()? : salesforce validation rules
What will happen if you try to update record in after trigger context?
How do singleton patterns work?
Use of import command in hadoop sqoop?
What is a smart object?
what has been your greatest achievement till now?