How to apply filtering criteria at group level with the having clause in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What is sql server database?
What are different types of views?
What should be the fill factor for indexes created on tables? : sql server database administration
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
Can we create nonclustered index in a table without creating a clustered index
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What is read committed?
Can we shrink data file in sql server?
what is a join? : Sql server database administration
How do I find the transaction log size in sql server?
How can sql injection be stopped? : sql server security
What is an active database?
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)