Suggest a method of joining two tables.
No Answer is Posted For this Question
Be the First to Post Answer
How to find the second highest salary of an employee?
Please explain what is “asynchronous” communication in sql server service broker?
find the 3rd max salary
2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID
What is transaction ? Give me one example.
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is an indexed view?
What is onf in normalization form?
in how many ways we can use count()
What is user-defined scalar function?
What does select 1 mean?
What about UPDATESTATISTICS ?
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)