Category: MS SQL

How to do limit and order by rand() in MS SQL?

How to do limit and order by rand() in MS SQL?

Posted on by agurchand

If you are a PHP or Java Developer you should be familiar with MySQL database right?

Table name: employee

Id Name Designation Dttime
1 Agurchand Software Engineer 2013-01-07 11:47:10
2 Babu Software Engineer 2013-01-02 01:06:00
3 Abhiesheik Broadcast Engineer 2013-01-10
…
Select query between two given dates in MySQL, MS SQL

Select query between two given dates in MySQL, MS SQL

Posted on by agurchand

Its very easy to select records between two different date in MS SQL and MySQL. Same kind of query will work in both the SQL engines.

Here is the query note it down or memorize for the future use, Its …

  • Archives

    • Theme: Overlay by Kaira. 
    Agurchand