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 car
12 16144Hi 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 CITY
5 9116here 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 d
7 9278Write 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_Name
7 12307please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.
1 6775can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?
1 9205Post New TCS SQL Server Interview Questions
is the xmlhttprequest object part of a w3c standard?
Explain an index segment?
explain advantages of myisam over innodb? : Sql dba
How often do you use social networking sites?
What does it mean to patch a file?
What is id?
Explain how can you debug the Java code?
Write a quert to import a file in sqoop?
Tell me in brief how sql server enhances scalability of the database system?
How do I stop a python script?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
How to organize layers in photoshop?
Why do we need services in angular?
What is water powerpoint?
1sq mm dc powr cable can carry how much dc currnt