How many types of functions are there in sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is the purpose of the sql select top clause?
What is the basic difference between a sql and stored procedure ?
Explain the rollback statement?
What is bitemporal narrowing?
What is a dynamic query?
How do we accept inputs from user during runtime?
what are the limitations of identity column? : Transact sql
How do I count duplicates in sql?
How to use boolean type in select statement?
Why left join is used in sql?
Types of joins ?
3 Answers Digital GlobalSoft, HeadStrong,
Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d
Oracle (3253)
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)