What is the difference between set and select?
No Answer is Posted For this Question
Be the First to Post Answer
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 temporal table?
What authentication modes does sql server support?
How to return the top 5 rows from a select query in ms sql server?
What is a Join and explain its types?
What is better - 2nd Normal form or 3rd normal form? Why?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What is storeprocedure?Tell me synatx for how to write stored procedure.
Explain the different index configurations a table can have?
What do you understand by triggers?
List some major differences between triggers and stored procedures?
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)