How do you exit in sql?
What are different types of indexes?
I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu
What is the fastest way of accessing a row in a table?
What are wait events. Describe the wait event tables.
What if we write return in procedure?
What does varchar include?
Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
What is normalization in sql?
What is partition by in sql?
What is trigger types in sql?
How do you concatenate in sql?