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 7534Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
5 13636Could 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 3670Below 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 2993Post New HSBC Interview Questions
What is mark and sweep algorithm?
How to fix the reinforcement in footing shorter bar at bottom and longer fix at top.
How do you check if a list exists to another in excel?
What will be the new characteristics of postgre 9.1?
tell my any difficult situtation you solved in your experience in your company?
When retrieving list items using sharepoint web services, how do you specify explicit credentials to be passed to access the list items?
What is code verification?
How do I create a cross reference in word 2016?
What is Hcm Master Data In Sap?
What is mean by error of submission? can u plz provide notes on this?
Difference between Pre-Validation step Vs Pre-Operation step?
How many pst files can you have in outlook?
What is the difference between Service Bus Queues and Storage Queues?
Can we join tables without foreign key?
Regarding , there is an air cooler which control the fans(50% of AV FANS) by temperature in outlet , and the louver of Air cooler is controlled by HIC from control system , So if on Air cooler we will consider 2 individual I/P converter or positioner?