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 15358Hi 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 8750here 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 8793Write 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 11830please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.
1 6607can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?
1 9046Post New TCS SQL Server Interview Questions
What is link?
In 4+ experience of sap basis administrator (in support side) in any company, what is roles and responsibilities in company and what he can do and what he should do in company? Please tell me because i want to apply with 4+exp. in sap basis and also pls tell me how to move further steps to get with these exp.Thank you.......
why do you want to do job in sbi bank?
Ap wkur,=p5 where wkur is a label?
What is frequncy?
A sieve analysis results in 100% retained in no. 50 Sieve, the fm is?
What is wordpress dashboard?
If we added one rider to the current SF market, how would that affect the existing riders and drivers?
How to clear complete cache in laravel?
What is the difference between pages and posts on wordpress?
Can S3 be used with EC2 instances, if yes, how?
Differentiate between file and structure storage structure.
What is the structure of phosphorous?
How to export the variable configuration from one environment to other?
What causes blue screen windows 10?