Can we use where clause with group by?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?
3 Answers Microsoft, TCS, Techastrum,
you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required
Security Question- SQL DBA exparts, need your help...
Explain few examples of stored procedure over triggers?
How can we solve concurrency problems?
what is a deadlock? : Sql server database administration
What is the contrast amongst drop and truncate?
what are the different types of replication you can set up in sql server? : Sql server database administration
Explain the concept of recursive stored procedure.
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
What is the use of nvl work?
Define views.
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)