What is pivot and unpivot?
No Answer is Posted For this Question
Be the First to Post Answer
Difference between aggregate functions of sql?
Describe in brief system database.
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What is the beast way to write CTE in SQL Server ?
Explain full-text indexing?
What are sql server procedures?
what's the difference between delete table and truncate table commands? : Sql server database administration
What is normalization of database?
What do you mean by the term 'normalization'?
How to get number of days in a given year?
How to list all triggers in the database with sys.triggers in ms sql server?
Why foreign key column allowing null values even a parent tables reference key column not having null value..
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)