What is the use of group by clause?
No Answer is Posted For this Question
Be the First to Post Answer
Write SQL queries on Self Join and Inner Join.
what is the difference between count(*) and count(1) ?
What is transaction server auto commit?
Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance
What is the sql case statement used for? Explain with an example?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?
What is data source object?
in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
How to declare and use cursor variables?
Can you explain what is sql server english query?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
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)