select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.
Can some one please help with a query which will take only max value of a column in a join.2 2730
WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...
After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )3 10606
if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..17 10793
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?3 4216
Explain Trigger with an example?2 10355
I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?3 3115
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What is difference between Triggers and store procedure?2 3495
How reterive duplicate value in SQL?6 7053
What is Transaction?2 4152
Explain aggregate functions?
Explain what are the authentication modes in sql server?
Explain what role entity and relationship play in an ER diagram.
What have included columns when we talk about sql server indexing?
What are sparse columns?
What are the authentication modes in sql server? How can it be changed?
How to populate a table in sql server?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
What is a join in sql?
What is the difference between count and distinct count?
Do you know how to implement service broker?
List some of the rules that apply to creating and using a ‘view’
How is a full-text index updated?
How do I know if localdb is running?
Explain relational data?