Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
- 0 Answers
- 1227 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is dynamic SQl and how you will create and execute dynamic sql?
I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu
Is join and inner join the same?
Explain the difference between 'between' & 'and' operators in sql
What are sql triggers used for?
What is the difference between null value, zero, and blank space?
What is full join?
Which is better cte or subquery?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
Is primary key always clustered index?
Which is better join or subquery?
table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678
-
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)
