What are the differences between “row_number()”, “rank()” and “dense_rank()”?
No Answer is Posted For this Question
Be the First to Post Answer
How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com
35 Answers Oracle, Scend, TechInfini,
A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?
How to concatenate two strings in SQL Server.
how will add additional conditions in sql?
0 Answers Amdocs, Apps Associates,
what is bit data type? and what are the information that can be stored inside a bit column?
Explain SELF JOIN ?
How to find the date and time of last updated table?
What are the different type of replication in sql server?
How to get a list of columns using the "sys.columns" view in ms sql server?
What is the difference between for trigger and after trigger?
How to invoke a trigger on demand?
your distribution database is full what will u do
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)