What is use of except clause? How it differs from not in clause?
- 0 Answers
- 602 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Can group functions be used in the order by clause in ms sql server?
How to bind a view to the schema of the underlying tables?
What is the difference between system objects and user objects?
Do you know what is user defined datatypes and when you should go for them?
Explain candidate key, alternate key, and composite key?
What are defaults? Is there a column to which a default can't be bound?
How do you run a trace?
How will u find the query which is running in some other machine
4 Answers CarrizalSoft Technologies, IBM,
Explain what are the different index configurations a table can have?
Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.
What is a transact-sql statement?
What is an extended Stored Procedure?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
