write an sql query to find names of employee start with 'a'? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75
How does a trigger work?
What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.
Authentication mechanisms in Sql Server ?
What are the main features of cursor?
Can 2 queries be executed simultaneously in a distributed database system?
Which join condition can be specified using on clause?
How many sql commands are there?
check whether all the emp numbers are indeed unique.
what are string data types? : Sql dba
What is procedure explain with example?
what are the advantages of using stored procedures? : Sql dba