What is the difference between rank and dense_rank?
No Answer is Posted For this Question
Be the First to Post Answer
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.
What is data compression?
What gets stored inside msdb database?
What kind of problems occurs if we do not implement proper locking strategy?
What is log ldf?
1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?
Do you know what is rank function?
Can we install sql server 2016 on windows 7?
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.
How to get the definition of a view out of the sql server?
Explain the various types of concurrency problem?
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)