How to use distinct and count in sql query? Explain


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

Is sql port 1433 encrypted?

0 Answers  


I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers   iGate,


I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,


Explain exception handling in pl/sql?

0 Answers  


what is bcp? When is it used?

0 Answers  






Does sqlite need a server?

0 Answers  


What is transaction control language (tcl)?

0 Answers  


mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com

5 Answers  


What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,


What is the difference between joins?

0 Answers  


Can we have two clustered index on a table?

0 Answers  


Is it possible to include an insert statement on the same table to which the trigger is assigned?

0 Answers  


Categories