write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car12 9908
How will u test the stroded procedures and functions? difference between SP and Triggers2 5339
Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY5 6272
how to improve the speed of SQL database server and how to avoid dead lock?1 4781
What is the disadvantages of index?3 6185
here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d7 5493
What is Primary key and foreign key? Give an example4 7305
what is the disadvantage of SQL Loder?1 5351
Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name7 7738
please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.1 4894
can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?1 7640
what is joins please explain breffly ??1 3441
What is the difference between Procedure and Function4 8731
Write the simplified mathematical Maclaurin's expansion for f(x,y).
what is message subfile?
How a new regional manager will manage and develop his new assigned territory?
What are the execution control statements?
Can you hide a primary page in a component? Reason?
how does an centrifugal and screw type chiller will work. which chiller efficiency is high and why.
Explain superblock in unix.
Which uplink/downlink spectrum is allocated to DCS-1800?
What is the disadvantage of context filters?
What is accounting transaction?
How to know the following data of synchronous generator 1. D-Axis Unsaturated Reactance 2. D-Axis Unsaturated Transient Reactance 3. D-Axis Unsaturated Sub - Transient Reactance
Am pass the 10000 records to target in target I will take commit interval 15000 when I was stop the work flow what will happened
Explain what are the steps to be taken to schedule the report?
Define piezo-electric effect?
What is stable sort example?