Interested to Buy Any Domain ? << Click Here >> for more details...
What is a DBMS, query, SQL?
- 0 Answers
- 1005 Views
- Maveric, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output
Explain the first normal form(1nf)?
write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?
What are extended events in sql server?
What are the differences between substr and charindex in sql server.
Explain the benefits of user-defined functions?
can you any body tell me the difference between candidate key and primary key
What is table level trigger?
Differentiate between a primary key and a unique key.
what is a live lock? : Sql server database administration
What is 1nf normalization form?
What do you understand by intent locks?
-
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)
