what is self join and why is it required? : Sql dba
Answer / suresh pagadala
Self join is nothing but the table performs join condition itself same table is called self join
| Is This Answer Correct ? | 0 Yes | 0 No |
Write a query to find the names of users that begin with "um" in sql?
What is the location of pre_defined_functions.
I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)
What is the largest value that can be stored in a byte data field?
take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...
Sql technical questions
if i perform any operation on views such as insert, delete etc will my base table get affected?????
What are the different datatypes available in PL/SQL?
What is an ndf file?
What is a transaction?
what is the difference between cluster and non cluster index? : Sql dba
How many databases can sql express handle?
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)