what is the difference between group by and order by in sql? : Sql dba
what is the difference between where clause and having clause? : Sql dba
Is sql microsoft?
What is query syntax?
what is rollback? : Sql dba
How can analyze query after generating explain plan ?
i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent
1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.
How to fetch alternate records from a table?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is compound trigger?
How do I write a cron which will run a sql query and mail the results to agroup?
What is plpgsql language?