What are various aggregate functions that are available?
No Answer is Posted For this Question
Be the First to Post Answer
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.
How to use union to merge outputs from two queries together in ms sql server?
What is wide table?
How do I run a trace in sql server?
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????
What is a materialized view?
Who is the owner of a schema in ms sql server?
What are the types of normalization?
Which are the important points to note when multilanguage data is stored in a table?
What do you mean by SQL injection attack?
Can you force a query to use a specific index?
Which are the new data types introduced in sql server 2008?
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)