In which situation you use Self joins?
We use Self Join, if we have a table that references itself.
For example, In the Employee Table below MANAGERID column
references EMPLOYEEID column. So the table is said to
referencing itself.This is the right scenario where we can
use Self Join.
Is This Answer Correct ? | 8 Yes | 0 No |
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
what are constraints? : Sql server database administration
What are the five characteristics of good data?
What is a sql join?
What is a Stored Procedure?
What is a cursor, index in sql?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
Can we call future method from queueable?
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 CITY
How we create SQL Server 2005 Reporting Services ? Give me Sample
Does order by actually change the order of the data in the tables or does it just change the output?
how to select a field with firstletter as capital and remaining are small letters