what is a self join? Explain it with an example? : Sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
Explain collation?
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?
Why use “pivot” in sql server?
What are user defined datatypes and when you should go for them?
Difference between rowid and rownum in SQL?
Explain stored procedure?
How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)
Will count(column) include columns with null values in its count?
What is normalization and what are the different forms of normalizations?
What languages bi uses to achieve the goal?
How efficient you are in oracle and SQL server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)